Loading and modifying products via SpreadSheet

{#loading-and-modifying-products-via-spreadsheet}

Products can be created and updated via spreadsheet. This is done in the Products section of the CMS. Make sure "Product" is selected on the left tab, then use the import form at the bottom to load your product spreadsheet.

General Info

{#general-info}

ProductID/SKU must be unique, otherwise duplicates will be overridden. If there is no ProductID, Title will be used instead.

If a column title matches a field on Product, it will be loaded in. eg if you specify an "AllowPurchase" column, the values will be loaded into each Product's AllowPurchase field. Clicking the "Show Specification for Product" link in the Products section of the CMS will help you identify the possible fields to import to.

You are not required to fill out all fields for each product row.

You can find a test spreadsheet in shop/tests/test_products.csv , which was exported from shop/tests/test_products.xls.

Assigning products to Categories

{#assigning-products-to-categories}

If you specify a 'Category' or 'ProductGroup' column, the loader will look for a ProductGroup with a title matching the specified category name. If you desire to use this system, it is recommended building your ProductGroup structure before loading the products.

Product Images

{#product-images}

Specifying a filename in a 'Image' or 'Photo' will link the product up to an image with the same filename that has been previously uploaded. This means you need to upload the product photos somewhere in the assets folder structure before doing the product bulk load.

The bulk loader does a search accross all folders for the right image. If you have filenames that are the same, you can specify the parent folder(s) to make the image reference unique. eg:

Image
banana.jpg
Products/apple.jpg
OtherProducts/apple.jpg

Note that case is ignored during this search.

Product Variations

{#product-variations}

There are 6 column names dedicated to variations: 'Variation1' - 'Variation6'. Each cell should use the following format: VariationType: value,value,value

eg: Size:extra small,small,medium,large,extra large

Note: be careful how you name variation types, because all of the variation values will be assigned to common variation types. Eg: you could mistakingly end up with the following: Size:extra small,small,medium,large,extra large,10,11,12,13,14

Trouble Shooting Tips

{#trouble-shooting-tips}

Make sure you don't have rouge spaces in your headings.

Settings before you load

{#settings-before-you-load}

Set this if you want categories to be created if they don't exist.

ProductBulkLoader::set_create_new_product_groups(true);

You can force every product to be in a certain category, as long as you know it's id:

ProductBulkLoader::set_parent_page_id(..id here...);

.

comments powered by Disqus