> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://sitegiant.crisp.help/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How To Bulk Update Webstore Listing

[1. Introduction](#1-introduction)  
[2. Export Products](#2-export-products)  
[3. Import 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 product, amend the products in the Excel file, and import it to your Webstore Listing when it is complete.

* \* \*

## 2. Export Products

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

![](https://storage.crisp.chat/users/helpdesk/website/51ecea09593eac00/efcfc361-31f3-44ce-83e5-aeb7ae_19ncgda.png)

**Step 2**: Choose to export **All Products** or **Selected Products** > Export
(Tick the product first before you click Export Products, then you will be able to choose Selected Products to just update for several products)

![](https://storage.crisp.chat/users/helpdesk/website/e6ea5c7f2a38e000/9969afca-3943-46f1-b8e7-2d76f2_1ckeckc.png)

**Step 3**: Download the Excel file from Exported List > Open the Excel file

![](https://storage.crisp.chat/users/helpdesk/website/35786df77bcf6000/bdc2da2e-93d7-488e-8453-d0f34b_s6387y.png)

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

![](https://storage.crisp.chat/users/helpdesk/website/aa2bc0d680ac9000/927ca3ec-1b84-4ccc-9af2-2046cc_1f3ayuz.png)

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

**Step 5**: To edit special\_price, the price is a required column

![](https://storage.crisp.chat/users/helpdesk/website/b0bc16a677088800/319b8cee-6377-4b42-9bb5-30b3e0_wz314p.jpeg)

**Step 6**: If the special\_price\_date\_start and special\_price\_date\_end columns are blank, then the special price will be offered without the due date

![](https://storage.crisp.chat/users/helpdesk/website/4864dfd25332e000/12fe0753-cc58-4d93-b3a8-8cc8f4_10qd8hx.jpeg)

**Step 7**: If the product listings have variants, the Option Name and Option Value columns must be in Excel together, and cannot be without each other

![](https://storage.crisp.chat/users/helpdesk/website/bcd9acf4443e1800/d532b590-6471-4e6e-bf08-0ca70b_x9yqpt.jpeg)

**Step 8**: inventory, set\_allocated\_stock, and allocated\_stock are used for display purposes only. Inventory update has to go through **Inventory adjustment** features, while **Allocated Stock** changes have to be performed in the system.

![](https://storage.crisp.chat/users/helpdesk/website/4d18e21c27eb2000/e095d416-9ccc-4576-8bcc-b30567_4hv81f.jpeg)

**Step 9**: Save the Excel file once done edit

* \* \*

## 3. Import Products

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

![](https://storage.crisp.chat/users/helpdesk/website/720901534a9d5000/bd6b70ee-fcf3-4802-b8e3-403930_xv37jl.png)

**Step 2**: Upload the Excel file > Next

![](https://storage.crisp.chat/users/helpdesk/website/45821ca33cabfc00/7b2de8d2-64d6-41f2-a198-6aa54a_1awl226.png)

**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.

![](https://storage.crisp.chat/users/helpdesk/website/b133f3d55d39b800/e4a3edeb-7035-4ae1-89ef-a2e952_dkxwaw.png)

### Related Articles:

1.  [How To Create New Webstore Listing (Without Variant)](https://support.sitegiant.com/knowledge-base/how-to-create-new-webstore-listing-without-variant/)
2.  [How To Create New Webstore Listing (With Variant)](https://support.sitegiant.com/knowledge-base/how-to-create-new-webstore-listing-with-variant/)
3.  [How To Manage Brands For Webstore Listing](https://support.sitegiant.com/knowledge-base/how-to-manage-brands-for-webstore-listing/)
4.  [How To Manage Product Collections](https://support.sitegiant.com/knowledge-base/how-to-manage-product-collections/)
5.  [How To Recommend Related Products To Your Customers](https://support.sitegiant.com/knowledge-base/how-to-recommend-related-products-to-your-customers/)

Tagged: [webstore listing](https://support.sitegiant.com/article-tags/webstore-listing/)

### Was this article helpful?

[Yes](#) [No](#)

**Need Support?**

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

[Contact Support](#)