Skip to main content

Import Inventory

How to access on Fynd Platform
Video: Fynd Platform - How To Bulk Upload Inventory

  1. Click Import.

    QG1

    Figure 1: Import Button

  1. Select Inventory.

    QG2

    Figure 2: Import Options

  2. Here, you can download a sample file for adding the inventory of products, either in Excel or CSV format.

    QG1

    Figure 3a: Download Excel Or CSV

    QG1

    Figure 3b: Sample Excel For Inventory Upload

    note

    The columns that are highlighted in green are mandatory to fill. You will get drop-down boxes for certain columns in the Excel file. Example: Gtin Type, Currency, etc

  3. You can start filling the inventory details as shown below. This is similar to the Edit Inventory section which you saw before. In this case, add the inventory details of those 3 products which were earlier imported using Excel.

    QG1

    Figure 4: Inventory Details In Excel

    info

    If you don't fill Actual Price and Selling Price columns, those price values will be taken from the product instead. Click here to know more.

  4. Now, you are ready to validate your Excel file. Upload your Excel file as shown below.

    QG1

    Figure 5: Validating And Uploading Excel File

  1. If the file is valid, you can upload your inventory. Click on Upload in the top-right corner. The bulk upload will initiate and it can be viewed under 'Upload History' as shown below. The upload status will be shown as 'Pending'. Wait till the status turns to 'Completed'.

    QG1

    Figure 6a: Batch Job In Progress

    You have successfully added an inventory to your products.

    QG1

    Figure 6b: Batch Job Successful

Your products will now appear on your website, with positive inventory.

note

What to do if the Excel file doesn't validate?

Use the Check Errors functionality, to find the issues and rectify them. QG1 QG1

Importing Bulk Inventory

The Bulk Inventory Import feature lets you update inventory and pricing for multiple products at once using Excel or CSV templates. This saves time and ensures consistency when managing large catalogues. You can import either:

  • Inventory data (quantities, stock type, etc.)
  • Price data (actual price, selling price, cost price, etc.)

1. Access Bulk Import

  1. Go to Products > All Products.

  2. Click Bulk Action > Import.

  3. Choose from the three available import types:

    • Product
    • Assets
    • Inventory (select this option)

2. Select and download a template

In the Upload Bulk Inventory screen:

  • Use the dropdown to choose one of the following:
    • Price Template
    • Inventory Price Template
  • Click Download Template to get a sample file in either .csv or .xlsx format.

3. Understanding the templates

Inventory Price Template

This template lets you update stock across different buckets (like damaged, not available, total) and apply logic using commands.

Columns in the template:

ColumnDescription
Seller IdentifierUnique product identifier (SKU)
Store CodeCode of the store where inventory applies
QuantityQuantity value to update
Inventory BucketType of stock to update: Total Quantity, Damaged, Not Available
CommandInstruction for how to apply the quantity
Expiration DateOptional – set product expiry date (if needed)

Supported Commands:

Command TypeFunction
AddAdds quantity to the existing value in the specified bucket
RemoveSubtracts quantity from the specified bucket
Set Total QuantityReplaces the current total quantity with the specified value
Set DamagedReplaces the damaged quantity and deducts it from total quantity
Remove DamagedSubtracts from damaged quantity and adds it back to total quantity
Set Not AvailableReplaces not available quantity and deducts from total quantity
Remove Not AvailableSubtracts from not available quantity and adds it back to total quantity

Price Template

This template updates the pricing details for multiple SKUs.

Columns in the template:

ColumnDescription
Seller IdentifierSKU of the product
Store CodeCode of the relevant store
Actual PriceOriginal base price
Selling PriceDiscounted or final price
CurrencyCurrency format (e.g., INR)
CommandUse Set to apply the prices
Cost PriceInternal cost of the product
Total QuantityOptional – update total quantity along with pricing
Expiration DateOptional – set expiry if relevant

4. Uploading your file

  1. Click Select File or drag and drop your completed .csv, .xls, or .xlsx file.
  2. Add any additional comments if needed (e.g., context, instructions).
  3. Click Upload.
note

Make sure your file matches the template structure exactly to avoid errors.

5. Validation Summary

After the upload completes, a Validation Summary appears:

  • Displays Total Records, Success, and Errors count.
  • If there are errors, click View Summary to inspect them in detail.

6. View Summary

Clicking View Summary opens a pop-up showing:

ColumnDescription
Seller IdentifierThe SKU with issue
Store CodeRelated store
Total QuantitySubmitted value
DamagedSubmitted value
Not AvailableSubmitted value
CommandInstruction applied
note

Rows with red highlight indicate invalid entries (e.g., logic mismatch, missing fields).

You can use this insight to correct the template and reupload only the failed records.

7. Review and validate

Once uploaded:

  • The Validation Summary displays:
    • Total records
    • Successful and failed records
  • If any errors are found, click View Summary to see:
    • Failure reasons
    • Problematic rows
    • Batch and uploader details

You can also:

  • Download the source file
  • View upload history
  • Filter by date range or upload status (Completed, Partial, Failed)

8. Upload status definitions

StatusMeaning
CompletedAll records were processed successfully
PartialSome records had errors
FailedNo records were uploaded

9. Track Upload History

At the bottom of the screen, the Upload History section lists all past uploads with filters for:

  • Batch ID
  • Date range
  • Upload stage/status

Status types:

StatusMeaning
CompleteAll entries uploaded successfully
PartialSome entries failed
FailedEntire upload unsuccessful

Click any record to view its full summary, including the source file, errors, and batch details like uploader name and processing time.