1. Go to Websuite > Products > Products.
  2. Click Import products.
  3. Choose which format you'd like to import from.
  4. Choose what type of import you are doing (adding or updating). Note you MUST include the right IDs if you are doing an update. The product export gives you these.
  5. A help box will appear telling you how to structure your file correctly. Make sure you read and follow the steps exactly.
  6. Once you've re-structured your file, click Choose file and select it from your computer.
  7. Click Next.
  8. Choose which New products you'd like to import.
  9. Optionally choose which categories & tags you'd like to associate to these products. We suggest you import in batches to add the correct products into the correct places.
  10. Click Import products.

Common mistakes

  • TITLE and NAME are different. TITLE is the friendly title for the product shown to the public. NAME is unique name for the product, primarily used in the URL. NAME must only contain letters, numbers and hyphens. No special characters or spaces. Note, if you don't include NAME, we create it automatically for you using the TITLE field.
  • TYPE_NAME must already exist under product types before you import, note it's the NAME not the TITLE that must match.
  • IMAGE_URL must be publicly accessible. A good way to test is to see if you can load the URL in your browser.
  • BADGE_LABEL must already exist under product badges before you import. The badge label must match.
  • CATEGORY_NAMES must already exists under product categories before you import, note it's the NAME not the TITLE that must match.
  • TAG_NAMES must already exists under product tags before you import, note it's the NAME not the TITLE that must match.
  • PRICE_CURRENCY_CODE_PRICING_TIER_NAME must have the correct CURRENCY_CODE and PRICING_TIER_NAME set and must already exist under currencies and pricing tiers before import. An example field would look like PRICE_USD_RETAIL.
  • CUSTOM_FIELD_NAME must already exist against the corresponding TYPE_NAME you've set. If the TYPE_NAME you've specified doesn't have the NAME you're using, it won't import it. An example field would look like CUSTOM_FIELD_ISBN