Home : Digital Asset Management : Programming OpenEdit : ECommerce Setup : Automated Loading

Automated Loading

Excel Importing
Quick Books
Retail Pro
Tab Delimited

Excel Importing

To a products to the store you can upload an excel spreadsheet into the /upload/ directory.

You can also use the Catalog admin area gui located here: /store/admin/uploadinventory.html

Format

The first row of the spreadsheet has these column headers in it:

SKU - This is a unique identifier. Typically related to the manufacturing code. Required
ProductID - This is used in the URL of the product page. Required.
ProductName - A short name of the product. This is used in search results and in the page title. Optional.
ProductDesc - A long description. This can include HTML code. Optional.
Keywords - Used on the web page so search engines will find the product. Optional.
CatalogID - A pointer to either a new catalog id or an existing one from /store/configuration/catalogs.xml. Optional.
CatalogName - A friendly name for this catalog. Optional.
Size - The size of this product. This is can be any text. Optional.
Color - A color option for this product. This can be text and is optional.
Price - This is the price for this specific size. This is optional number with decimal such as 2.32.
Weight - This is a decimal number that represents the weight of the product. Can be used to calculate shipping. Optional
Quantity - This is the number of items that are in stock. Optional.

Any columns after Quantity will be added to the item as a property. A property can be retrieved with this notation $item.propertyname

Example

You can download an example spreadsheet from here: inventory.xls

Tab Delimited

To import products add a file located in your /store/upload/inventory.csv

Once it is processed without errors it will be deleted.

Fields

Each field is separated by a tab character.

SKU - This is the item level SKU should be unique at least within a product
ProductID - This is a unique id can be characters. Should not have spaces.
ProductName
ProductDesc - Can be a long HTML description. Be aware that it does not have tabs in it. Can also be blank
Keywords - Comma separated values
Categories - Comma separated ID's. Will add them if they are missing
Retail Price - Can be without $ such as 234.33
Your Price
Size
Color
Weight
Inventory   This is a count
Attribute(s) Any remaining columns will be added as a generic properties on the item.

Example

SKU    ProductID    ProductName    ProductDesc    Keywords    Categories    Retail Price    Your Price    Size    Color    Weight    Inventory    Attribute1
33015    PAAAAAHLKMGFAPBO    $1,000 Gift Card                $1,000.00     $1,000.00                 100
33016    PAAAAAOEDBGGAPBO    $1,500 Gift Card                $1,500.00     $1,500.00                 100
33001    PAAAAALDJFEFAPBO    $10 Gift Card                $10.00     $10.00                 100