Skip to main content

Using Email Inventory Extension

Introduction

When the quantity or price of products and articles change, you need to provide us with the updated data. To achieve this, you can use the Email Inventory extension to send the inventory of your selling locations (stores) to us. Once you mail us your inventory data in Excel or CSV, we will accordingly update the inventory on Fynd Platform.

note

Once you have installed this extension, it will be available in the Extensions section on Fynd Platform.


QG1


In this document, you'll know more about:


Features

QG2


Inventory Setup

Here you can set up your email, the file format, and the selling locations (stores) whose inventory you'll send.

Email Configuration

  1. Email

    • Sender Email Address - Enter the email ID you'll use to send the inventory file.
    • Subject Line - Enter a text that you'll always keep common in the subject line of every email. This will be helpful for us to identify your emails.
    • Read All Unread Emails - We only consider your latest email for updating your inventory. However, if you want us to read all your emails, turn ON this option.
  2. File

    • File Type - Choose whether you'll send inventory data in Excel or CSV format.
      If you choose CSV, use the Delimiter field to tell us whether the data is separated using comma (,), semicolon (;), a tab (\t), a space (), or a pipe (|).
      If you choose Excel, add one or more sheet names that you want us to read, or turn ON the Read all the sheets option so that we look into all the sheets present within the Excel file, rather than specific sheets.
    • Download Sample File - Use this to download a sample file that you can use to fill and send your inventory data to us.
  3. Inventory Specify all the rules and criteria before fetching the inventory.

    • Minimum Price - We will not fetch the inventory of those articles which fall below the price you specify here.
    • Minimum Acceptable Stock - We will not fetch the inventory of those articles whose quantity is not greater than the specified value.
    • Inventory Frequency - Specify at what interval you'll send us your inventory. You'll receive a notification in case the inventory data fails to reach us.
    • Inventory Execution Type - Choose how to treat the inventory data you send us via email.
      • Infinite Quantity Inventory - Choose this if your products have no fixed quantity such as 'made to order' products (e.g. furniture, jewellery, eyewear, etc.)
      • Parent-Child Combination Inventory - Choose this if you deal in composite products, i.e., individual parts assembled to form a final product (e.g. motherboard, sofa, etc.)
      • Full Inventory - This is the default type.
  4. Advanced (optional) Tell us how to find the inventory data in your Excel/CSV file in case you have written it differently.

    • File is a downloadable link - Turn ON this option, if you've included a link to your inventory file in the email. We will download the Excel/CSV directly from the link.
    • File is compressed - Turn ON this option, if your inventory exists in a compressed file and needs to be extracted by us. Also, mention the zip format (.zip or .gzip).
    • File is character encoded - If you have selected CSV as the file type, choose whether the file is/will be encoded in UTF-8 or UTF-16. This encoding type is generally chosen by you while saving the file.
    • Consider selling price from catalogue - Choose whether you want us to ignore the selling price from your inventory file and instead consider the price mentioned in your Fynd Platform catalogue.
    • Does your file have a header row - Turn on this option if your file has headers (seller identifier, loc code, etc.)

    QG2

    QG2

    • Edit Header Row Of the File - Help us find out the header names you've used for Location Code, Product Identifier, Quantity, and Selling Price in your Excel/CSV file. This is especially useful when you customize the header names and use something different than the suggested names.

Location Opt-In

Here you can choose (opt-in) the selling locations whose inventory you would mail us so that we can update on Fynd Platform. Once you opt-in a selling location, enter its Location ID. We will find that Location ID in the inventory sheet (Excel/CSV) and take its corresponding inventory data into Fynd Platform.

QG11


Analytics

Here you can view a colour-coded representation of the data related to your inventory.

Article Level - View the graph of articles received, processed, deleted, and uncatalogued during the selected time period.

QG2


Location Level - View the graph of stores that we found to be non-existing in Fynd Platform, not opted-in by you, and the ones we believe were duplicates during the selected time period.

QG2


Item Level - Items may come in different SKU/articles for e.g. a t-shirt (product) may come in different sizes S, M, L, XL (articles). View the graph of actual no. of products represented by the articles.

QG2


History

Once we receive your inventory data in Excel or CSV, depending on your configurations, we initiate an inventory job to process the received data.

QG11


You can check the no. of inventory jobs executed, and how many of them failed on a given date.

You'll see a timeline of inventory jobs containing the following details.

  1. Time (e.g. 12:00 AM)
  2. Initial - The articles that were initially sent by you.
  3. Processed - The articles we processed as per your configuration, after excluding the deleted and suppressed articles.
  4. Deleted - The articles we deleted because you didn't opt-in a store or the store is closed.
  5. Suppressed - The articles whose quantity we made zero.
  6. Status - Success/Failure
  7. Technical Details - Using this, you can check all the steps executed in the inventory. It will also help you identify the exact step at which an inventory job failed.

Analytics

QG11


The analytics section shows the count of parameters you should know about. You can use the drop-down to select the time period for which you wish to view the analytics data.

  1. Total Articles Processed
    Shows the count of articles that were processed during the selected time period. We arrive at this count by deducting the no. of articles that were not processed due to the following reasons:

    • You didn't opt-in a store but still sent us its inventory.
    • You sent us an inventory of those articles that don't exist in your Fynd Platform catalogue.
    • You sent us an inventory of articles whose quantity is zero.
  2. Total Articles Not Catalogued
    Shows the count of articles you sent us by email but they don't exist in your Fynd Platform catalogue during the selected time period.

  3. Stores Not Opted
    Shows the count of selling locations (stores) that were not opted-in for sending their inventory during the selected time period.

  4. Duplicate Stores
    Shows the count of duplicate selling locations found during the selected time period.

tip

View the Resources section on the Email Inventory screen to know more about the extension.