CMS Product Import
From NewHaven Software Wiki
Dan hacker (Talk | contribs) |
Dan hacker (Talk | contribs) |
||
| 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.
