Lijst met gegevens
Modellijst voor het invoeren van producten in het shoppla.eu platform.
In plaats van elk product afzonderlijk in te voeren, is het ook mogelijk om in één keer een volledige lijst van producten toe te voegen. Hiervoor is het wel nodig om de juiste informatie op de juiste plaats en op een correcte manier in te vullen.
Hieronder kan je een lijst terugvinden met de verschillende informaties over je producten die je in het systeem kan invoeren. De lijst zelf kan je in bijlage terugvinden.
| CSV Column Name | Maps to product property | Example | Notes |
|---|---|---|---|
ID | id | 100 | Defining this will overwrite data for that ID on import. |
Type | type | simple, variation, virtual | Product Type. Valid values: simple, variable, grouped, external, variation, virtual, downloadable. Multiple types can be used CSV separated. |
SKU | sku | my-sku | Required. Auto-generated if missing. |
Name | name | My Product Name | Required. |
Published | status | 1 | 1 for published, 0 for private, -1 for draft. |
Is featured? | featured | 1 | 1 or 0 |
Visibility in catalog | catalog_visibility | visible | Supported values: visible, catalog, search, hidden |
Short Description | short_description | This is a product. | |
Description | description | This is more information about a product. | |
Date sale price starts | date_on_sale_from | 2013-06-07 10:53:15 | Date or leave blank. |
Date sale price ends | date_on_sale_to | 2013-06-07 10:53:15 | Date or leave blank. |
Tax Status | tax_status | taxable | Supported values: taxable, shipping, none |
Tax Class | tax_class | standard | Can use any existing tax class. |
In stock? | stock_status | 1 | 1 or 0 |
Backorders allowed? | backorders | 1 | 1, 0, or notify |
Sold individually? | sold_individually | 1 | 1 or 0 |
Weight (unit) | weight | 100 | Parse only numbers. |
Length (unit) | length | 20 | Parse only numbers. |
Width (unit) | width | 20 | Parse only numbers. |
Height (unit) | height | 20 | Parse only numbers. |
Allow customer reviews? | reviews_allowed | 1 | 1 or 0 |
Purchase Note | purchase_note | Thanks for buying it buddy. | |
Price | price | 20.99 | May set sale or regular price depending on other columns. |
Regular Price | regular_price | 24.99 | Non-sale price. |
Stock | manage_stock / stock_quantity | 20 | Numeric stock level enables stock management. parent can be used for variations. Blank = no stock management. |
Categories | category_ids | Category 1, Category 1 > Category 2 | CSV list of categories. > used for hierarchy. |
Tags | tag_ids | Tax 1, Tag 2 | CSV list of tags. |
Shipping Class | shipping_class_id | Name | Name of shipping class |
Attribute 1 Name | attributes | Color | Looks for global attribute or uses text if not found. Include as many as needed. “Used for variations” is set automatically. |
Attribute 1 Value(s) | attributes | Blue, Red, Green | List of values. Variations only need 1 value. First is used if multiple get provided. |
Attribute 1 Default | default_attributes | Blue | Default value for variable products. |
Attribute 1 Visible | attributes | 1 | 1 or 0. Mapping screen labels this as “Attribute Visibility” |
Attribute 1 Global | attributes | 1 | 1 or 0. Mapping screen labels this as “Is a global attribute?” |
Images | image_id / gallery_image_ids | http://somewhere.com/image.jpg, http://somewhere.com/image2.jpg | First is featured image. |
Download 1 Name | downloads | Download 1 | |
Download 1 URL | downloads | url.zip | |
Download Limit | download_limit | 1 | n/a or a limit. |
Download Expiry Days | download_expiry | 1 | n/a or a day limit. |
Parent | parent_id | id:100, SKU-1 | Set parent ID. Used for variations. Can be just a numeric ID e.g. id:100 or a SKU. Export will use SKU when possible. |
Upsells | upsell_ids | id:100, id:101, SKU-1, SKU-2 | List of IDs. Can be just a numeric ID e.g. id:100 or a SKU. Export will use SKU when possible. |
Cross-sells | cross_sell_ids | id:100, id:101, SKU-1, SKU-2 | List of IDs. Can be just a numeric ID e.g. id:100 or a SKU. Export will use SKU when possible. |
Position | menu_order | 1 | Menu order, used for sorting. |