Importing Products

You can import product data into Goodsie in spreadsheet format by uploading a CSV or Excel XLS file. This is useful for transferring product information from another service, updating product inventory values in one batch, or for performing other operations to a group of products in one step.

When you upload a product spreadsheet, Goodsie searches for a product with the same SKU (specified in the second column, as outlined below). If it finds one, the existing product will be updated. If no product with the row's SKU is found, Goodsie will add the row as a new product.

The spreadsheet you upload should contain the following columns from left to right:

Name: Product's name
SKU: Product SKU
Description: Product's full description
Short Description: Product's short description
Price: Product's default price
Sale Price: Price used when product is on sale
Quantity: Available product quantity as an integer. "Unlimited" or "-1" for unlimited
Status: One of "available", "on sale", "hidden", "sold out", or "coming soon"
Type: One of "physical" or "digital"
Shipping Group: The name of the product's shipping group. Leave empty for none
Tax Group: The name of the product's tax group. Leave empty for none
Category 1: Category 1-5 are names of categories to which the product belongs
Category 2: Category 1-5 are names of categories to which the product belongs
Category 3: Category 1-5 are names of categories to which the product belongs
Category 4: Category 1-5 are names of categories to which the product belongs
Category 5: Category 1-5 are names of categories to which the product belongs
Image 1: Image 1-10 are URLs of product images or videos. Goodsie will grab the image or video from the web and use it for your product
Image 2: Image 1-10 are URLs of product images or videos. Goodsie will grab the image or video from the web and use it for your product
Image 3: Image 1-10 are URLs of product images or videos. Goodsie will grab the image or video from the web and use it for your product
Image 4: Image 1-10 are URLs of product images or videos. Goodsie will grab the image or video from the web and use it for your product
Image 5: Image 1-10 are URLs of product images or videos. Goodsie will grab the image or video from the web and use it for your product
Image 6: Image 1-10 are URLs of product images or videos. Goodsie will grab the image or video from the web and use it for your product
Image 7: Image 1-10 are URLs of product images or videos. Goodsie will grab the image or video from the web and use it for your product
Image 8: Image 1-10 are URLs of product images or videos. Goodsie will grab the image or video from the web and use it for your product
Image 9: Image 1-10 are URLs of product images or videos. Goodsie will grab the image or video from the web and use it for your product
Image 10: Image 1-10 are URLs of product images or videos. Goodsie will grab the image or video from the web and use it for your product
Option Name: Currently ignored. Included in Goodsie Product Export
Option Fee: Currently ignored. Included in Goodsie Product Export
Option Quantity: Currently ignored. Included in Goodsie Product Export
Extra Name: Currently ignored. Included in Goodsie Product Export
Extra Fee: Currently ignored. Included in Goodsie Product Export
Extra Quantity: Currently ignored. Included in Goodsie Product Export

If you like, you can download this CSV template to get started:
goodsie_products.csv

The following fields are required: SKU, name, price, quantity, status, type. If others are left blank, this will not affect your ability to upload the document to Goodsie.

When you export your products from Goodsie, the resulting CSV includes extra rows beneath each product row for options and extras. When importing, Goodsie will ignore rows that contain only Option or Extra information.

Note: Please be sure to use http:// for product image URLs.