Welcome to the One Stop Order Processing help desk
Search the Knowledge Base
Knowledgebase - Click on the section titles to see more categories and articles: Magento > Products
How To Import Products From CSV File
Posted by Zoe Strassen, Last modified by Zoe Strassen on 23 October 2017 11:25 AM

How To Import Products From CSV File

To import products from a CSV file you will need to make sure that you adjust your headers to the compatible headers that are listed below.

Products

Minimum requirements for an import file
You must have at least 1 of the red fields in your import file to create a valid One Stop Order Processing product.

Field Name
This should appear in the first line of the file

Description
SKU Your product code , e.g. IL507. If you are using the import for different platforms (e.g. Ebay and Amazon) you must use the SKU field to identify the product.
EAN European Article Number, normally used as the 13 digit barcode, e.g, 7352648596042
Title Name of the product, e.g. 1922 Dodge Car Model RT5
Description Brief description of the product, more details about the product.
Price Price to sell the product to the customer, e.g. 12.92
ShipCost The shipping cost of this product (to the customer), e.g. 1.99
VATRate VAT rate of product, e.g. 15
Weight The weight of the product in Kilos, e.g. 8.1
Currency The currency to be used for this product, e.g. £
Type The type of the product. This is used to filter the product on when viewing and amending, e.g. shoes
CostPrice The cost price of the product. This is used to calculate the profit on sales, e.g. 9.82
ShipCostPrice The actual shipping cost of the product, e.g. 1
BinLocation The location to find the product in the warehouse. This is used when producing the picking list, e.g. AISLE 3
UseStockControl Use stock control on this product? When orders are imported the stock levels are adjusted, e.g. 1, means use Stock Control. 0 means don't.
CurrentStock Current stock of the product, e.g. 92. When importing if you put a + before the amount this increase the current stock level by the amount given. For example, if the current stock level is 10 and you import a value of +3 the stock will now be 13. You can also use a - to decrement stock aswell. For example, if you sold stock outside of One Stop Order Processing and want to update the stock levels.
SiteStock Stock allocated to a particular selling platform (and being sold), e.g. 6. Means 6 are currently available on Ebay as a buy it now.
ReorderStockLvl At what stock level do you want to be notified about? After orders have been imported any product levels that reach this level will be displayed and you can reorder stock for that product. e.g. 3
OutOfStockLvl At what level do your products become out of stock? This is used when listing products on Amazon, Ebay etc..You may want more than 0 as an out of stock level, so you still have a product to use for samples, demos.
Supplier Who is the supplier of this product. This is used for producing supplier reorder documents and other supplier related activities. e.g. AMZ
Notes Your own notes on the product.
SellingPlatform

The platform that this product is being sold on. This can be one of the following values:
0 - All platforms
1 - Ebay
2 - Amazon
3 - PlayTtrade
4 - SellerDeck/Actinic
5 - OSOP (One Stop Order Processing, for telephone and adhoc orders).
6 - Googlebase (Google Shopping)
7 - Edirectory
8 - Shopzilla
9 - Interspire
10 - Edirectory
11 - X-Cart


Each selling platform can have different values for the following information:

Title, Description, Price, ShipCost, VATRate, Currency, SellingPlatform, Brand, Manufacturer, ProductType, Condition, Image1, Image2, Image3, Image4, Image5, SearchTerms, WebPage, Category, SellingFormat, Duration, Availability, OriginalPrice, ShippingDest, ASIN, CustVal1, CustVal2, CustVal3, CustVal4, CustVal5, CustVal6, CustVal7, CustVal8, CustVal9, CustVal10, CustVal11, CustVal12, CustVal13, CustVal14, CustVal15, CustVal16, CustVal17, CustVal18, CustVal19, CustVal20, SiteStock

Brand The Brand of the product, e.g. Tillers
Manufacturer The manufacturer of the product, e.g. Wilkers
ProductType The type of product, e.g. Shoe
Condition Is the product New, Second Hand or Refurbished
Image1 The web address (or local for TurboLister) for an image of the product. e.g. http://www.567carn.co.uk/images/pic1.jpg
Image2 A 2nd image of the product
Image3 A 3rd image of the product
Image4 A 4th image of the product
Image5 A 5th image of the product
SearchTerms Search terms used to find product. e.g. trainer,shoe,fashion
WebPage The webpage where this product can be bought. This is specific to products like SellerDeck/Actinic, osCommerce. e.g. http://www.567carn.co.uk/products.php?812
Category The selling platforms selling section. e.g. Computers
SellingFormat The type of sale for the product, e.g. Fixed Price
Duration How long the sale of the item is for. e.g. 7
Availability How soon can the product be sent, e.g. 1, meaning 1 day.
OriginalPrice The original price of the item. This is used for sales and price reductions on sites like Amazon. e.g. 19.99
ShippingDest Where the item will ship to, e.g. UK.
ASIN The Amazon product code, e.g. B020TFXHIC
CustVal1 Custom values specifically related to this site type. This allows you to add up to 20 different product details related to your business
CustVal2
CustVal3
CustVal4
CustVal5
CustVal6
CustVal7
CustVal8
CustVal9
CustVal10
CustVal11
CustVal12
CustVal13
CustVal14
CustVal15
CustVal16
CustVal17
CustVal18
CustVal19
CustVal20
sActinic The SKU code for the product if sold on SellerDeck/Actinic. This is used to list and adjust stock for SellerDeck/Actinic sales.
sAmazon_mp The SKU code for the product if sold on Amazon Marketplace. This is used to list and adjust stock for Amazon Marketplace sales.
sAmazon_sc The SKU code for the product if sold on Amazon SellerCentral. This is used to list and adjust stock for Amazon SellerCentral sales.
sCube_cart The SKU code for the product if sold on Cube Cart. This is used to list and adjust stock for Cube Cart sales.
sEbay The SKU code for the product if sold on Ebay. This is used to list and adjust stock for Ebay sales.
sEbid The SKU code for the product if sold on eBid. This is used to list and adjust stock for eBid sales.
sOne_stop The SKU code for the product if sold on One Stop Order Processing. This is used to list and adjust stock for One Stop Order Processing sales.
sOscommerce The SKU code for the product if sold on osCommerce. This is used to list and adjust stock for osCommerce sales.
sPlaytrade The SKU code for the product if sold on Rakuten. This is used to list and adjust stock for Rakuten sales.
sRoman_cart The SKU code for the product if sold on RomanCart. This is used to list and adjust stock for RomanCart sales.
sEdirectory The SKU code for the product if sold on Edirectory. This is used to list and adjust stock for Edirectory sales.
sInterspire The SKU code for the product if sold on Interspire. This is used to list and adjust stock for Interspire sales.
sXCart The SKU code for the product if sold on X-Cart. This is used to list and adjust stock for X-Cart sales.
sSupplier2 Who is the 2nd supplier of this product. This is used for producing supplier reorder documents and other supplier related activities. e.g. MAQ
sSupplier3 Who is the 3rd supplier of this product. This is used for producing supplier reorder documents and other supplier related activities. e.g. EE2
bUseStockDays IWhen automatically finding stock reorder level select if a set number of days should be used
nLeadTimeDays Number of days that a supplier takes to deliver supplies
nReorderDays Number of days to hold stock for
nStockCalcMode Which stock calulcation mode to use. Avalue of 0 means calculate stock based on a certain number of days (the days is in the nReorderDays field). A value of 1 means used the sales figures based on the last nStockCalcDays days. Value of 2 means calculate the stock to hold the mininum stock level.
nStockCalcDays Number of days of sales to use to calculate the reorder level for.
nStockPackSize The number of items in a pack when ordering (.e.g how many items in a box does the supplier sell the item in).
bAddLeadTime Add on lead time when recalculating reorder stock level
nMinimumLevel Minimum stock to hold
nSellPackSize The number of this item that is supplied when this item is sold (e.g. when the customer buys this they get 2 boxes of cards)
sComponentID IDs of other products that are supplied when this item is supplied.
sComponentQty Quantity of products that are supplied when this item is supplied.
bComponentsOnOrder Show the components on the order, so that if they buy the this item, the others are included on the order.
ID ID of this order. This must be included if you are using components etc..

(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: