CSV Column Names

This is not a complete guide

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.

Product Detail

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)


Price Groups / Trade Pricing

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


Stock / Inventory

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


Supplier Details

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


Show Buy button

P_SHOWBUYBUTTON Show Buy Button on product (t = show)

Index Previous Next