Array ( [0] => Array ( [0] => Array ( [label] => Home [link] => https://support.sitegiant.com/en [title] => Home [type] => blog_home ) [1] => Array ( [label] => Products [link] => https://support.sitegiant.com/en/article-categories/products-en/ [title] => View all posts in Products [type] => kb_tax ) [2] => Array ( [label] => How To Bulk Update Webstore Listing [link] => https://support.sitegiant.com/en/knowledge-base/how-to-bulk-update-webstore-listing/ [title] => How To Bulk Update Webstore Listing [type] => kb_current_page ) ) [1] => Array ( [0] => Array ( [label] => Home [link] => https://support.sitegiant.com/en [title] => Home [type] => blog_home ) [1] => Array ( [label] => Sales Channel : Webstore [link] => https://support.sitegiant.com/en/article-categories/webstore/ [title] => View all posts in Sales Channel : Webstore [type] => kb_tax ) [2] => Array ( [label] => How To Bulk Update Webstore Listing [link] => https://support.sitegiant.com/en/knowledge-base/how-to-bulk-update-webstore-listing/ [title] => How To Bulk Update Webstore Listing [type] => kb_current_page ) ) )
  1. Products
  2. How To Bulk Update Webstore Listing
  1. Sales Channel : Webstore
  2. How To Bulk Update Webstore Listing

How To Bulk Update Webstore Listing

1. Introduction
2. Export Products
3. Import Products

1. Introduction

Too many products to update in a short time? Instead of updating all your products one by one in the system, you can now export all your products, amend the products in the Excel file, and import them to your Webstore Listing when it is complete.


2. Export Products

Step 1: Navigate to Products > Webstore Listing > More(…) > Export Product.

Step 2: Choose to export All Products or Selected Products > Export.

Step 3: Download the Excel file from Exported List > open the Excel file.

Step 4: Modify the product details in the Excel file.

?Note: You may delete the column which will not be updated except for the required (*) column.

ColumnDescriptionSample Data
parent_sku *Parent SKU for variant grouping1p-dk-3
type *Single product or group productproduct: single product
group: with variants
name *Product nameDK-3 ATX RGB Tempered Glass Gaming Casing Chassis
iskuLinked inventory item SKU1p-dk-3-White
sku *Product code1p-dk-3-White
brandBrand name2NDPLAYER
free_shippingWhether offer free shippingno / yes
option1 nameVariant 1 option nameColour
option1 valueVariant 1 option valueBlack / White
option2 nameVariant 2 option nameSize
option2 valueVariant 2 option valueS / M / L
weightWeight of the product5
weight_unitUnit of the weightkg / g / oz / lb
length(Dimension) length of the product (cm)50
width(Dimension) width of the product (cm)25
height(Dimension) height of the product (cm)45
costCost price50
priceUnit price100
special_priceDiscount price70
special_price_date_startDiscount start date (YYYY-MM-DD)2023-09-01
special_price_date_endDiscount end date (YYYY-MM-DD)2023-12-31
inventoryStock quantity1000
set_allocated_stockWhether allocate a certain quantity to sell on webstoreno / yes
allocated_stockStock quantity of the allocated stock20
descriptionProduct specification content. Require HTML code to align the content.<p>This is the description.</p>
sortingProduct sorting in webstore0,1,2,3…
visibilityCondition to publish productpublish / unpublish
taxableWhether the product has tax chargesyes / no
imageImage link to upload as product thumbnailhttps://…

Step 5: To edit the special_price column, the price column is a required column.

Step 6: If the special_price_date_start and special_price_date_end columns are blank, then the special price will be offered in the long term without a due date.

Step 7: If your product has variants, the option name and option value columns must be imported together, and cannot be without each other.

Step 8: The inventory, set_allocated_stock, and allocated_stock are used for display purposes only. Inventory update has to go through Stock Adjustment features, while Allocated Stock changes have to be performed in the system.

Step 9: Save the Excel file once done edit.


3. Import Products

Step 1: Navigate to Products > Webstore Listing > More(…) > Import Products.

Step 2: Upload the Excel file > Next.

Step 3: If there are any errors in the Excel uploaded, you will see the error message in Errors and Warnings and it will show the error column in the Data Preview. Amend the error column and reupload the file. Click on Proceed if the file uploaded does not have errors.

Step 4: Wait for the system to process the imported file. Refresh to see the changes. If the progress bar becomes green, it means the file is successfully uploaded.

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support