Channel Products Import Fields

Article author
Store Automator
  • Updated

You can change channel inclusion settings for each item with the help of bulk action files.

StoreAutomator has the ability to import and execute bulk action files prepared to perform a specific purpose. You can change channel inclusion settings for each item with the help of bulk action files. Channel product import fields can be found below.

Provide all column names in English for proper addressing of your feed. Store Automator accepts .xlsx, .csv, .txt, .zip file formats. The file size should not exceed 20MB. Below is a list of Channel Product Import Fields for the system to process your data at a minimum level.

The 1st cell of the 1st column must have the following text: channelproduct.sku

This cell can also be[channel_number].Channelproduct.sku,this syntax will apply the procedure to all items in that channel, and channel_name field must be omitted.

Following column headers can be one of the field names (except sku) listed below. Name Fields can be in any sequence

 

Optional fields

Name

Description

Notes

P,C,S

Sku

SKU

Max, 50 characters, SKU is needed to create a product cannot be changed, required

P,C,S

Channel_name

Channel Name

Required unless the first cell includes channel number before channelproduct.sku

P,C,S

title

Title of the item

 

P,C,S

Brand_name

Brand Name of Product

 

P,C,S

price

Price of the item

 

P,C,S

sale_price

Sale price if the item is on sale, SalePrice

 

P,C,S

sale_price_start_date

Start date of the item sale price, SalePriceStartDate

Date format: YYYY-MM-DD

P,C,S

sale_price_end_date

The end date of the item sale price, SalePriceEndDate

Date format: YYYY-MM-DD

P,C,S

MSRP

Manufacturer’s Suggested Retail Price, MSRP

 

P,C,S

MAP

Minimum Advertised Price, map

 

P,C,S

price_factor

Price factor for this item

 

P,C,S

tax

Tax Percentage of TaxClassId

E.g.: 2001234

C, P

business_price

Business price of the item

 

 

quantity_price_type

Quantity price type of the item

 

 

quantity_price_X

1<X<5

 

 

quantity_lower_bound_X

1<X<5

 

 

is_fba

If the item is FBA capable

Values: Yes, no, true, false

 

product_id

Barcode or Specific product id, Barcode

 

C

product_id_type

Item barcode or specific product id type, BarcodeType. Value to be selected amongst UPC, EAN, ISBN, ASIN, GCID, GTIN, EPID

Default value: UPC’

C

ship_weight

Ship weight of the item

 

 

ship_days

Shipping days of the channel

 

 

Shipping_template

 

ship_template

Shipping template of the channel

Either value is acceptable

 

ship_price

Ship price of the item

 

 

ship_cost

Ship cost of the item

 

 

handling_cost

Handling cost of the item

 

 

masking_quantity

Masking quantity of the item

 

 

forced_stock_status

Forced stock status of the item

Values: none, out_of_stock, in_stock, in_stock_1, In_stock_3, in_stock_5, in_stock_10,in_stock_20, in_stock_50,

 

in_stock_100

 

orderable

If the item is orderable

Values: Yes, no, true, false

 

sku_override

Sku override of the item

 

 

asin_override

Asin override of the item

 

 

fast_listing_enabled

If Fast listing was enabled for the item

Values: no, yes, false, true, auto, manual

 

item_template

Item template of the item

 

 

enable_product_update

Switch allows Item-based product updates.

Values: Yes, no, true, false

C,P,S

 

Click here to download the file

Was this article helpful?

0 out of 0 found this helpful