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