Hoe voeg je een lijst van producten toe in het platform?

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 NameMaps to product propertyExampleNotes
IDid100Defining this will overwrite data for that ID on import.
Typetypesimplevariation, virtualProduct Type. Valid values: simple, variable, grouped, external, variation, virtual, downloadable. Multiple types can be used CSV separated.
SKUskumy-skuRequired. Auto-generated if missing.
NamenameMy Product NameRequired.
Publishedstatus11 for published, 0 for private, -1 for draft.
Is featured?featured11 or 0
Visibility in catalogcatalog_visibilityvisibleSupported values: visiblecatalogsearchhidden
Short Descriptionshort_descriptionThis is a product. 
DescriptiondescriptionThis is more information about a product. 
Date sale price startsdate_on_sale_from2013-06-07 10:53:15Date or leave blank.
Date sale price endsdate_on_sale_to2013-06-07 10:53:15Date or leave blank.
Tax Statustax_statustaxableSupported values: taxableshippingnone
Tax Classtax_classstandardCan use any existing tax class.
In stock?stock_status11 or 0
Backorders allowed?backorders11, 0, or notify
Sold individually?sold_individually11 or 0
Weight (unit)weight100Parse only numbers.
Length (unit)length20Parse only numbers.
Width (unit)width20Parse only numbers.
Height (unit)height20Parse only numbers.
Allow customer reviews?reviews_allowed11 or 0
Purchase Notepurchase_noteThanks for buying it buddy. 
Priceprice20.99May set sale or regular price depending on other columns.
Regular Priceregular_price24.99Non-sale price.
Stockmanage_stock / stock_quantity20Numeric stock level enables stock management. parent can be used for variations. Blank = no stock management.
Categoriescategory_idsCategory 1, Category 1 > Category 2CSV list of categories. > used for hierarchy.
Tagstag_idsTax 1, Tag 2CSV list of tags.
Shipping Classshipping_class_idNameName of shipping class
Attribute 1 NameattributesColorLooks for global attribute or uses text if not found. Include as many as needed. “Used for variations” is set automatically.
Attribute 1 Value(s)attributesBlue, Red, GreenList of values. Variations only need 1 value. First is used if multiple get provided.
Attribute 1 Defaultdefault_attributesBlueDefault value for variable products.
Attribute 1 Visibleattributes11 or 0. Mapping screen labels this as “Attribute Visibility”
Attribute 1 Globalattributes11 or 0. Mapping screen labels this as “Is a global attribute?”
Imagesimage_id / gallery_image_idshttp://somewhere.com/image.jpg, http://somewhere.com/image2.jpgFirst is featured image.
Download 1 NamedownloadsDownload 1 
Download 1 URLdownloadsurl.zip 
Download Limitdownload_limit1n/a or a limit.
Download Expiry Daysdownload_expiry1n/a or a day limit.
Parentparent_idid:100SKU-1Set parent ID. Used for variations. Can be just a numeric ID e.g. id:100 or a SKU. Export will use SKU when possible.
Upsellsupsell_idsid:100, id:101SKU-1, SKU-2List of IDs. Can be just a numeric ID e.g. id:100 or a SKU. Export will use SKU when possible.
Cross-sellscross_sell_idsid:100, id:101SKU-1, SKU-2List of IDs. Can be just a numeric ID e.g. id:100 or a SKU. Export will use SKU when possible.
Positionmenu_order1Menu order, used for sorting.