From the "Inventory" >> "Import Cataglog" section of the administration control panel of your store it is possible to import your product catalog from a CSV file of any format. CubeCart will provide a prompt for you to select a CSV file from your local computer. After upload you can choose with a dropdown menu to select which field you want to import it against.
Below is a table of the possible fields identifiers with notes and example data. If your CSV has matching column headers to those in the table below CubeCart will automatically match up the columns to the fields. If these are not found you can manually match them up.
| Column Headers | Description | Accepted Value | Notes | Example | Generated Automatically if empty |
|---|---|---|---|---|---|
| status | Status | Number | 1 or 0 | 1 | |
| name | Product Name | Text | X4 Quadcopter | ||
| image | Main Image | Text | Document root relative path from the images/source folder. Before CSV import all images much have been uploaded to this folder and the image database updated using the "Update File List" button in the images filemanager section of your admin control panel. It is possible to comma seperate multiple images. |
hus_x4quad.jpg or hus_x4quad.jpg,hus_x4quad2.jpg |
|
| product_code | Product Code | Text | H107C | Yes | |
| cat_id | Master Category ID | Number/Text | Category id of an existing category. From 5.2.14 this can be comma seperated for multiple categories. This can also be a text value. If the category name is not found it will be created. |
23 or Drones |
|
| description | Description | Text | The new Hubsan X4 LED edition features a whole host of new... | ||
| manufacturer | Manufacturer | Text | Hubsan | ||
| price | Price | Decimal | 59.99 | ||
| sale_price | Sale Price | Decimal | 33.29 | ||
| cost_price | Cost Price | Decimal | 23.55 | ||
| product_weight | Weight | Decimal | 0.454 | ||
| use_stock_level | Use Stock Level | Number | 1 or 0 | 1 | |
| stock_level | Stock Level | Number | 75 | ||
| stock_warning | Stock Level Warning | Number | Threshold you want stock warnings to show. | 5 | |
| digital | Is Digital Download | Number | 1 or 0 | 0 | |
| digital_path | File path/name.ext | Text | Absolute server path to download file | /var/downloads/file.zip | |
| tax_type | Tax Class | Number | Tax Class ID | 2 | |
| tax_inclusive | Tax Inclusive | Number | 1 if the price above includes tax, 0 if not | 0 | |
| latest | Include in latest homepage products | Number | 1 or 0 | 1 | |
| featured | Include in featured products | Number | 1 or 0 | 1 | |
| seo_path | Custom SEO URL Path | Text | Custom URL address | hubsan-x4 | Yes |
| seo_meta_title | Meta Title | Text | Meta title on product detail page | X4 Quadcopter | |
| seo_meta_keywords | Meta Keywords | Text | Meta keywords on product detail page | X4 Quadcopter with Camera,Hubsan,H107C | |
| seo_meta_description | Meta Description | Text | Meta description on product detail page | X4 Quadcopter with Camera: Toys & Games | |
| condition | Condition | Text | Google Base specification. More info. | new, refurbished or used | |
| upc | UPC Code | Text | |||
| ean | EAN Code | Text | |||
| jan | JAN Code | Text | |||
| isbn | ISBN Code | Text | |||
| brand | Brand | Text | |||
| gtin | GTIN Code | Text | |||
| man | MPN Code | Text |
Comments
0 comments
Please sign in to leave a comment.