On the Back Office : Exporting existing products and options from each stores

On each store :

  1. Go to the store Back Office Product Page and click Export CSV

  2. Name the CSV after the store name

On Excel : adding SKU on similar products across both stores

  1. Create a new excel document

  2. For each store : Save the CSV Export of the store as a store tab in the excel document

  3. For each store : On the store tab of the store, delete info of all columns except ProductId and Name but keep headers

  4. Create a "merge" tab with the following columns :

    • Column 1 : All Product and Options names of the "Name" column of all store tabs without duplicates with header "Name"

    • Column 2 : leave empty with header "SKU"

  5. For each store : add one column with Product ID of the Store using vlookup with Name column of the Store from the Store Tab with header the name of the store

  6. Update the new tab : manually merge rows with similar products that have Product / Option Name discrepancies between the stores

  7. Manually populate SKU Column with required SKU for each product name

On Excel : Preparing CSV Import Files

For each store :  

  1. Create a new tab with the headers of the original exported CSV from any Product CSV Exports

  2. Populate the ProductId column with the ProductId column of the store from the merge tab

  3. Populate the SKU column with the SKU column from the merge tab

  4. Populate : the Name column with Name column from the merge tab

  5. All other columns empty except the headers

  6. Export the tab in CSV with semicolon as separator

On the Back Office : updating products and options with SKU

For each store :  

  1. Go to the store Back Office Product Page and click Import CSV

  2. Select the generated CSV of the store

  3. Click OK

The store products and options are updated with SKU