CMS Product Import: Difference between revisions
Dan hacker (talk | contribs) No edit summary |
Dan hacker (talk | contribs) No edit summary |
||
| Line 5: | Line 5: | ||
CMS-Products | CMS-Products | ||
CMS | CMS-SKU | ||
CMS- | CMS-Inventory | ||
CMS- | CMS-PriceCategory | ||
CMS- | CMS-Warehouse | ||
CMS- | CMS-Prices | ||
| Line 22: | Line 22: | ||
== CMS-SKU == | |||
CMS-SKU is the secondary product spreadsheet containing data related to SKU level properties. This includes fields like "Weight", "Length", "UPC", and "VendorSKU". This spreadsheet is related to the "CMS-Products" spreadsheet via the "ProductCode" field. | |||
== CMS- | |||
== CMS-Inventory == | |||
Revision as of 22:45, 19 February 2020
CMS has the ability to import products from predefined spreadsheets. There are six spreadsheets in total, although not all are used in every situation.
The six spreadsheets are:
CMS-Products
CMS-SKU
CMS-Inventory
CMS-PriceCategory
CMS-Warehouse
CMS-Prices
CMS-Products
CMS-Products is the base product spreadsheet containing data that is solely related to the main product code (without consideration for color/size/SKU). The fields roughly correspond to what you would see at the product level if you were looking at a product in the "Product Information" window. Besides the product code itself, the spreadsheet contains fields such as "InvoiceDescription", "Brand", "AllowDecimal", and "DoesNotShip".
This spreadsheet covers all of the essential top-level settings for a product and can be used to import basic product information.
CMS-SKU
CMS-SKU is the secondary product spreadsheet containing data related to SKU level properties. This includes fields like "Weight", "Length", "UPC", and "VendorSKU". This spreadsheet is related to the "CMS-Products" spreadsheet via the "ProductCode" field.
