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 https://www.help.cms-tool.net/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) |
More From This Section
You can upload product data via CSV
Upload data from CSV. This advanced feature enables you to import product lists from third parties or from your accounting system. This feature is an advanced feature, intended for very technical users and is not provided with any warranty nor free support. We suggest you only attempt use on a new or trial site, and do not use without training on a site with an existing product inventory
How to link your existing Xero account in order to push through draft orders to Xero.
You can export your product information straight out of MYOB into the Content Management System.
What to do when customers want to order products offline
Your website has a product feed you can connect to your Commerce Manager catalog via the Meta (Facebook) Product Feed plugin.
You can now integrate with Fastway couriers API for more focused freight pricing and printing of labels.
Some common questions regarding the klaviyo feed
Learn how to migrate your website from Shopify. This includes Product data, photos, customers, and order history.
FAQ Topics
Building your site
Advanced Page Types
E-Commerce
- Shopping Basics
- Category Management
- Products
- Product Options
- Layout and Formatting
- Payment Options
- Processing Orders
- Advanced Ecommerce
- Product Pricing, Currencies
- Plugins
- Wholesale
- Rental, Booking and Appointment Systems
- Freight - Couriers
- Stock & Quantities
- Vouchers, Discounts, Loyalty Points
- Selling Photos / Prints
- Shopping Cart Add-on Page types
- Advanced APIs / Add ons
- Point of Sale (POS)
- Reports
- Orders / Invoices
Email & Membership
- Member Management
- Members Pages / Template Customisations
- From Addresses and Reply To Email Notifications
- Global Enquiry form options
- Standard Field Names
- Webmail
- Bulk Email
- CRM Features
- Email Campaigns
- Forums & Blogs
- Pop3/Imap Email Services
- Scams and Hoaxes
- Lead Magnets / Growing Your Customer Database
- Form Spam Filtering
