5. How to bulk import auction products

Import Steps

  • Download sample csv.
  • Fill the sample csv as per below table.
  • Go to WooCommerce > All Products > Import > Upload CSV file.

Values to be entered in CSV File

General CSV guidelines
  • CSVs should be in UTF-8 format.
  • Any dates should be defined for the store's local timezone.
  • Taxonomy term hierarchy is denoted with >, terms are separated with commas.
  • Serialised data is not supported.
  • Images need to be pre-uploaded or available online in order to import to your store.
  • User can define the filename if the image already exists in the media library.

CSV file columns and Valid values

Woocommerce fields
No CSV Column Name Maps to Product Column Example Notes Required or Optional
01 ID same as column name 100 [leave blank] when importing new products, Defining this will overwrite data for that ID on import. Opt.
02 Type same as column name auction Valid values: [ auction ]. Define Type of product Req.
03 SKU same as column name my-sku Autogenerated if missing Opt.
04 Name same as column name My Product Name Name of Product Req.
05 Published same as column name 1 Valid Values : [ 1, 0, -1 ]. 1 for published, 0 for private, -1 for draft. Req.
06 Is featured? same as column name 1 Valid values: [ 1, 0 ]. Product is featured product or not. Opt.
07 Short description same as column name This is auction product. Short description about product Opt.
08 Description same as column name This is more information about a product. Detailed description about product Opt.
09 In stock? same as column name 1 Valid values: [ 1 ] Req.
10 Stock same as column name 1 Valid values: [ 1 ] Req.
11 Sold individually? same as column name 1 Valid values: [ 1 ] Req.
12 Visibility in catalog same as column name visible Valid values: [ visible, catalog, search, hidden ] Req.
13 Categories same as column name Tshirts, Clothing > Hoodies List categories seperated by comma(,) and Use > for hierarchy. Opt.
14 Tags same as column name Electronics, Art, Computer List tags seperated by comma(,) Opt.
15 Images same as column name http://somewhere.com/image.jpg, http://somewhere.com/image2.jpg First is featured image and others are gallery images Opt.
16 Weight (kg) same as column name 1.5 Parse only numbers. Opt.
17 Length (cm) same as column name 10 Parse only numbers. Opt.
18 Width (cm) same as column name 6.5 Parse only numbers. Opt.
19 Height (cm) same as column name 4 Parse only numbers. Opt.
20 Tax status same as column name taxable Valid values: [ taxable, shipping, none ] Opt.
21 Tax class same as column name standard Can use any existing tax class. Opt.
22 Allow customer reviews? same as column name 1 Valid values: [ 1, 0 ] Opt.
23 Purchase note same as column name Thanks for buying it. Opt.
24 Shipping class same as column name ship_abroad Name of shipping class Opt.
25 Attribute 1 name Attribute name Color Name of Attribute Opt.
26 Attribute 1 value(s) Attribute value(s) Blue, Red, Green Values of Attribute Opt.
27 Attribute 1 default Default attribute Blue Default value for Attribute Opt.
28 Attribute 1 visible Attribute visibility 1 Valid values: [ 1, 0 ] Opt.
29 Attribute 1 global Is a global attribute? 1 Valid values: [ 1, 0 ] Opt.
Auction fields
No CSV Column Name Maps to Product Column Example Notes Required or Optional
30 Auction - Selling Type same as column name both Valid values: [ both, auction, buyitnow ] Req.
31 Auction - Product Condition same as column name new Valid values: [ new, used ] Req.
32 Auction - Auction Type same as column name normal Valid values: [ normal, reverse ] Opt.
33 Auction - Enable Proxy Bid same as column name 0 Valid values: [ yes, 0 ] See details Opt.
34 Auction - Enable Slient Bid same as column name 0 Valid values: [ yes, 0 ] See details Opt.
35 Auction - Opening Price same as column name 150 Opening price must be > 0 Req.
36 Auction - Lowest Price to Accept same as column name 800 Lowest price must be >= 0 Req.
37 Auction - Bid Increment same as column name 10 Bid inc must be >= 0 or [leave blank]. See details Opt.
38 Auction - Enable Variable Increment same as column name yes Valid values: [ yes ] or [leave blank] See details Opt.
39 Auction - Variable Increment same as column name 150-300-10*300-500-20*500-onwards-30 Valid values: [ use format ] or [leave blank] See details Opt.
40 Auction - Buy Now Price same as column name 1700 Buynow price must be >=0 Req.
41 Auction - Start Date same as column name 2019-10-25 17:45:20 Valid values: [ use format ] Req.
42 Auction - End Date same as column name 2020-03-25 17:45:20 Valid values: [ use format ]. End date must be > start date Req.
43 Auction - Enable AutoRelist same as column name yes Valid values: [ yes ] or [leave blank] Opt.
44 Auction - Enable Recurring AutoRelist same as column name yes Valid values: [ yes ] or [leave blank] Opt.
45 Auction - Enable AutoRelist If WinnerNotPaid same as column name yes Valid values: [ yes ] or [leave blank] Opt.
46 Auction - If WinnerNotPaid Relist After (hours) same as column name 15 Hours must be >= 0 or [leave blank] Opt.
47 Auction - Enable AutoRelist If NoBids same as column name yes Valid values: [ yes ] or [leave blank] Opt.
48 Auction - If NoBids Relist After (hours) same as column name 11 Hours must be >= 0 or [leave blank] Opt.
49 Auction - Enable AutoRelist If ReservePriceNotMet same as column name yes Valid values: [ yes ] or [leave blank] Opt.
50 Auction - If ReservePriceNotMet Relist After (hours) same as column name 25 Hours must be >= 0 or [leave blank] Opt.
51 Auction - AutoRelist Duration (hours) same as column name 600 Hours must be >= 0 or [leave blank] Opt.
Format for variable increment :
startprice-endprice-inc*startprice-endprice-inc*startprice-onwards-inc
Use * to join more than one variable increments

E.g.
1) 100-200-10
2) 400-500-30*500-600-40
3) 2400-2500-10*2500-2600-20*2600-2700-30
4) 400-500-30*500-onwards-40
5) 100-200-10*200-500-30*500-onwards-40

Note : "onwards" increments will be added only once, not more than one time

Format for start date :

yyyy-mm-dd hh:mm:ss
E.g. 2019-11-03 22:50:33
year-month-date hour:minute:second


Format for end date :

yyyy-mm-dd hh:mm:ss
E.g. 2019-11-03 22:50:33
year-month-date hour:minute:second


How to set bid increment :
Note : At a time, only one type of bid increment will be added either simple or variable

E.g. How to set simple bid increment :
Bid Increment : 10
Enable Variable Increment: [leave blank]
Variable Increment: [leave blank]
E.g. How to set variable bid increment :
Bid Increment : [leave blank]
Enable Variable Increment: yes
Variable Increment: 100-400-10*400-700-20

How to set bid type in auction :
There are 3 types of bid type in auction
1) Simple bid (default)
2) Proxy bid
3) Slient bid

Note : At a time, only one type of auction bid will be added either proxy or slient but not both

E.g. How to set auction as simple bid :
Auction - Enable Proxy Bid : 0
Auction - Enable Slient Bid: 0
E.g. How to set auction as proxy bid :
Auction - Enable Proxy Bid : yes
Auction - Enable Slient Bid: 0
E.g. How to set auction as slient bid :
Auction - Enable Proxy Bid : 0
Auction - Enable Slient Bid: yes

Still need help? Send Your Query Send Your Query