Update Price and inventory

How to Update Products in Bulk via File Upload

Keeping your product listings accurate is essential for managing your store effectively. The "Update Products via File" feature allows you to make bulk changes to your existing products—such as updating inventory levels, prices, packaging information, SEO details, or even images—all at once using a simple file upload. This method is incredibly efficient for sellers who need to manage a large catalog without editing each product individually.

Video Tutorial

For a visual walkthrough of the process, please watch our detailed video tutorial below.

Step-by-Step Instructions

This process is divided into two main parts: downloading the template with your current product data, and uploading it after making your changes.

Part 1: Downloading the Product Update Template

  1. From your seller dashboard, navigate to Products > Update Products via File.
  2. On the "Download template" page, you will see a list of data fields you can update. Select the checkboxes for the information you wish to change. For example, to update stock levels and prices, check Inventory and Price.
  3. Click the Download the data file to update button. An Excel file containing your selected product data will be downloaded to your computer.

Update+Products+via+File+Downloading+the+Product+Update+Template.png

Part 2: Editing and Uploading the File

1. Editing the Downloaded File

  • Open the downloaded Excel file. You will see columns for Product ID, Vendor Code, Product Name, and the fields you selected to update (e.g., Inventory, Price).
  • Locate the product you want to change and modify the values in the appropriate columns. For example, change the number in the "Inventory" column or the value in the "Price" column.
  • Once you have made all your changes, save the file.
Important: Do not change the Product ID or Vendor Code columns. These are unique identifiers used by the system to match your updates to the correct products.

Update+Products+via+File+Editing+and+Uploading+the+File.png

2. Uploading the Updated File

  • Return to the Fyaril dashboard and click the Next button.
  • On the "Upload and Update" page, click Choose File and select the Excel file you just saved.
  • Click the Upload Data File button.
  • The system will process the file. You will see success notifications on the screen, and your product listings will be updated automatically. You can verify the changes by checking your product list.

Update+Products+via+File+Uploading+the+Updated+File+-+Copy.png

Frequently Asked Questions (FAQ)

1. What data fields can I update using this file upload method?

You can update several key data fields, including Inventory, Price, Packaging Info, SEO (like meta titles and descriptions), and Images. Simply select the corresponding checkboxes in the "Download template" step to include those fields in your file.

2. What happens if I change a Product ID or Vendor Code in the file by mistake?

Changing these unique identifiers will cause the system to fail to recognize the product you are trying to update. The update for that specific row will not be processed. Always leave the Product ID and Vendor Code columns untouched.

3. Can I use this method to add new products?

No, this tool is designed exclusively for updating existing products. To add new products in bulk, you should use the "Add Products in Bulk" or "Import products through file" options, which are different processes.