Importing Products from Shopify

by ONELIVE Webmaster
How to export Products from Shopify and import into TITAN.

Download Product Listings

  1. Go to Settings > Company Settings.
  2. Click Company Name from the list.
  3. Open Toolbox (upper lefthand sidebar) 
  5. Go to Website > Sellercloud Integrated Website > Shopify General.
  6. Choose Download Listings from the dropdown menu.
  7. Click Go. (It will download a csv into your downloads folder.)
  8. Note: Open the CSV and make sure there is a SKU for all products BEFORE importing to SellerCloud. If there are missing SKUs, add the missing SKUs into Shopify and then download listings again.
  9. Go to Inventory > Import Product Info.
  10. Select Company.
  11. Choose Company Name from the pulldown menu.
  12. Select Plugin.
  13. Choose Shopify Product Import. (If option doesn't exist, email SellerCloud to add)
  14. File "Choose File"
  15. Click Import Products Info.
  16. It will queue a job which runs a schedule of tasks and can take up to an hour depending on the amount of products and the queue in SellerCloud. It will set up the initial SKUs, in this step, you will need to resolve any missing Parent SKUs on products with variants. SellerCloud has a Parent / Child relationship in terms of SKUs, and Shopify does not, so you must add them into SellerCloud. This step does not import images and descriptions.

Upload Product Listings to Shopify

The SellerCloud import function does not carry over the images or descriptions, so that must be done after the products are initially imported.
  1. Login Shopify Store Admin.
  2. Click Products from the side menu.
  3. Click Export.
  4. From the popup
    1. Select All products
    2. Select Plain CSV file
    3. Click Export products.
  5. Open the CSV in Excel and edit to match the SKUs set up in the SellerCloud export file.
  6. Remove all columns besides the columns below and rename them:
  7. Body(HTML) -- LongDescription
  8. Variant SKU -- ProductID
  9. ImageSrc -- DescriptionAndGalleryImageURL
  10. Move Product ID to be the first column
  11. Save the file as .xls
  12. Note: ImageSrc and Variant Image needs to be combined into one column and any URLs from Variant Image needs to be transferred over to the ImageSrc column. There should only be 3 columns when finished.
  13. Note: Task this item to Bret on all stores to run script on CSV to automate this task.

Upload Into TITAN

  1. Go to Inventory > Bulk Update Products.
  2. First Column Type Product ID.
  3. Update Products from company: Choose Company Store Name from pulldown menu.
  4. Select File: Click Choose File.
  5. File Type: Choose Excel. 
  6. Click Submit.
  7. Note: If you get an error attempting to update the newly edited CSV, save it as an Excel file and try again.
Back to Inventory