But may help provide guidance for what column names the CSV Importer / Exporter used.
When importing a CSV column names do not need to match those shown below. You can specify what the column data represents from a dropdown above each column.
For best results, export a current CSV of your product data with the values set to determine the appropriate column name the CMS uses.Some options may only be able to be exported not imported if exporting using the ALL option.
Ensure your P_CODE / SKU column is the first column on the spreadsheet.
P_CODE | Product / SKU Code | |
P_TITLE | Product Title | |
P_IMG | Main Product Image (Image must exist at the location and be a full url of an external site https://example.com/product.jpg or relative to the file location in the hosting account e.g /images/product.jpg) | |
P_PRICE | Checkout Price (excl tax) | |
P_PRICEPREDISCOUNT | RRP Price (excl tax) | |
P_SHOWBUYBUTTON | Show Buy Button (t=show,f=hide) | |
P_ENQUIRY | Show Enquiry Form (t = show) |
P_PRICEA | Price Group A | |
P_PRICEB | Price Group B | |
P_PRICEC | Price Group C | |
P_PRICED | Price Group D | |
P_PRICEE | Price Group E | |
P_PRICEF | Price Group F | |
P_PRICEG | Price Group G | |
P_PRICEH | Price Group H |
P_QTYINSTOCK | Product Quantity In Stock | |
P_QTYLOWSTOCK | ||
P_BACKORDER_MAXQTY | Backorder Quantity allowed when out of stock | |
P_TARGET_QUANTITY | ||
P_QTYINC | Quantity Increments | |
P_MINQTY | Min Quantity available for purchase | |
P_MAXQTY | Max Quantity available for purchase | |
P_MINQTYTRADE | Min Quantity available for trade customers / trade pricing groups | |
P_UOM | Unit of Measure description | |
P_QTY_LABEL | Quantity Label | |
P_OUTOFSTOCKMESSAGE | Product Availability Message | |
P_LOCATION | Stock Location | |
P_PRIVATE_STOCK_NOTES | Stock Notes (Confidential) | |
P_ITEMCONDITION | Item Condition - Only Select options available - Export report to see option used | |
P_STOCK_DISPLAY | Dispay Setting - Only Select options available - Export report to see option used |
P_SUPPLIER_PUQ | ||
P_SUPPLIERPRICE | Supplier Price | |
P_SUPPLIERCODE | Supplier Code | |
P_SUPPLIERNAME | Supplier Name | |
P_MANUFACTURER | Manufacturer Make | |
P_MANUFACT_SKU | Manufacturer Code | |
P_MADEINCOUNTRY | Manufacturer Country |
P_SHOWBUYBUTTON | Show Buy Button on product (t = show) |