# Bulk Upload (Inventory Tool)

You can access this section from the **left**[ ](https://app.zonwizard.com/profit/massive-upload/) menu inventory [**>> Bulk** upload](https://app.zonwizard.com/analytics/massive-upload/)**.**

In this section you can upload information about the following information by uploading Excel files:

* **Inventory quantity**
* **Procurement time**
* **Shipping Time to Amazon**
* **Product details (SKU, dimensions and weight)**
* **Set the same internal SKUs as the Marketplace SKUs**
* **Add vendors to the master data**
* **Bundled Products**
* **Products ordered**
* **Combining products**
* **Packaging templates**

### Bulk upload - Inventory Quantity <a href="#id-6mmw9rl46s7m" id="id-6mmw9rl46s7m"></a>

In this section, you can upload information about the inventory quantities of the products in your warehouse.

{% hint style="success" %}
This information is required as an initial system setup. Once the quantities have been set, the system will automatically keep the stocks updated, scaling the products shipped (sales orders, product shipments to Amazon warehouses) and adding the incoming products from purchase orders to suppliers.
{% endhint %}

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FMqSZ9sglomdM9BkmePkw%2Fimage.png?alt=media&#x26;token=14625b49-1d7e-4c50-8e56-71740e9d59e1" alt="" width="436"><figcaption></figcaption></figure>

It is possible to download different templates for uploading data:

* **Inventory template**: contains only the headers and must be filled in line by line by the user.
* **Inventory template to configure**: includes products that don't have an inventory quantity set.
* **Current inventory template:** contains the quantities currently assigned to each product in your inventory.

All templates contain the following information that must be filled in line by line:

* **Product \[sku or asin]**: Product identification code. It is also possible to refer to the internal SKU if previously set.
* **Quantity**: Total quantities of pieces per product

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2F25okR9VUgm8NnQ3MNBvd%2Fimage.png?alt=media&#x26;token=76295b88-7e1c-409d-a087-3086af57506c" alt=""><figcaption></figcaption></figure>

### Bulk Upload - Procurement Time <a href="#id-19iz3c7z4aa2" id="id-19iz3c7z4aa2"></a>

In this section you can upload and update in bulk the information relating to the procurement times of your products (by ASIN or SKU): i.e. the time from the order to the supplier when it arrives in your warehouse

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2F0G2H4mRF3D8J2kLy0ffR%2Fimage.png?alt=media&#x26;token=ea07af7c-1f49-4916-8149-4da023ecde13" alt="" width="434"><figcaption></figcaption></figure>

It is possible to download different templates for uploading data:

* **Procurement Template**: contains only the headers and must be filled in line by line by the user.
* **Current Restock Times Template**: includes the supply times currently allocated to each product in your inventory

All templates contain the following information that must be filled in line by line:

* **Product \[sku or asin]**: Product identification code. It is also possible to refer to the internal SKU if previously set.
* **Restock Time \[dd]** : the number in days relating to the time of arrival of the goods in the warehouse

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2Fq1VPt3NPYsFf5Oj5AR3U%2Fimage.png?alt=media&#x26;token=0c4ff4ef-2034-43aa-b82f-d7a57a3f5007" alt=""><figcaption></figcaption></figure>

### Bulk Upload - Shipping Time to Amazon <a href="#id-19iz3c7z4aa2-1" id="id-19iz3c7z4aa2-1"></a>

In this section, you can upload and update information about the shipping time of your products to Amazon (by ASIN or SKU) in bulk: i.e. the time from the moment you send a shipment to Amazon until the products are available for sale.

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2F6boodVm9VszRVXh5oTFp%2Fimage.png?alt=media&#x26;token=77fb56e9-2ac9-4100-aa78-3e2143227a57" alt="" width="437"><figcaption></figcaption></figure>

It is possible to download different templates for uploading data:

* **Shipping to Amazon template**: contains only the headers and must be filled in line by line by the user.
* **Shipping Time to Current Amazon Template**: includes the shipping times to Amazon currently set for your products

All templates contain the following information that must be filled in line by line:

* **Product \[sku or asin]**: product identifier
* **Ship-to-Amazon Time \[dd]\*** : the number in days related to the arrival time of the goods on Amazon

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FK1XXJ5JAHA04w4gDtROK%2Fimage.png?alt=media&#x26;token=f04da7eb-8732-45e9-951f-e03db274c489" alt=""><figcaption></figcaption></figure>

### Bulk Upload - Product Details <a href="#id-19iz3c7z4aa2-2" id="id-19iz3c7z4aa2-2"></a>

In this section, you can upload and update your product detail information (by ASIN or SKU) in bulk:

* internal SKU
* dimensions
* weight

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FFHN01qr1vfKOrqu6kW1X%2Fimage.png?alt=media&#x26;token=a75d4559-6046-42ff-92a7-cf563accc87b" alt="" width="435"><figcaption></figcaption></figure>

It is possible to download different templates for uploading data:

* **Product details template** : contains only the headers and to be filled in line by line by the user.
* **Current Product Detail Template:** includes the details currently assigned to each product in your inventory

All templates contain the following information that must be filled in line by line:

* **Product \[sku or asin]**: Amazon product identifier
* **Internal SKU (optional)** : Internal identification code
* **Length \[cm] (optional):** length in cm
* **Width \[cm] (optional)**: depth in cm
* **Height \[cm] (optional):** height in cm
* **Weight \[gr] (optional)**: weight in grams

|                            |                             |                             |                            |                             |                             |
| -------------------------- | --------------------------- | --------------------------- | -------------------------- | --------------------------- | --------------------------- |
| **Product \[sku or asin]** | **Internal SKU (optional)** | **Length \[cm] (optional)** | **Width \[cm] (optional)** | **Height \[cm] (optional)** | **Weight \[gr] (optional)** |
| SKU0\_1204                 | 99666                       | 10                          | 6                          | 5                           | 880,0                       |
| SKU\_181031                | 4412PP                      | 15                          | 10                         | 5                           | 1450,0                      |
| SKU\_1020                  | YHUKK                       | 8                           | 3                          | 5                           | 1000,0                      |

### **Set internal SKUs the same as Marketplace SKUs** <a href="#imposta-gli-sku-interni-uguali-agli-sku-del-marketplace" id="imposta-gli-sku-interni-uguali-agli-sku-del-marketplace"></a>

With this option, you can automatically assign SKUs so that internal SKUs match Marketplace SKUs

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FwKnVkN2iFiSuC2ZdZLcj%2Fimage.png?alt=media&#x26;token=2af890d1-3cc1-4c00-9a79-2110e04a3df0" alt="" width="563"><figcaption></figcaption></figure>

### **Set inventory value based on product costs from profit tool**

With this option you can automatically set the inventory value of your products based on the costs you defined in the Profit Tool.

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FHolQpP5aTJ0p0h0IKfCX%2Fimage.png?alt=media&#x26;token=23f62104-59dd-42c5-b189-ee77c8d20a9e" alt="" width="563"><figcaption></figcaption></figure>

### Bulk Upload -Suppliers <a href="#fornitori" id="fornitori"></a>

Here you can add your suppliers in bulk

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FURRUhNe3f2lTVK0jim20%2Fimage.png?alt=media&#x26;token=0e602f0b-85a0-4f47-9403-944eed3dada5" alt="" width="563"><figcaption></figcaption></figure>

It is possible to download different templates for uploading data:

* **Supplier Template**: contains only the headers and to be filled in line by line by the user.
* **Existing Supplier Templates:** includes suppliers currently already entered in the master data of the [Inventory-Suppliers](https://app.zonwizard.com/analytics/supplier/list/) section

All templates contain the following information that must be filled in line by line:

* **Name :** company name or other identifying name of the supplier
* **Currency (EUR, USD, GBP..)** : the currency used by the supplier at the time of the order
* **Country code (US - IT - CN..) :** the country code of the supplier
* **Street:** address intended as street and house number
* **Zip code: t**he supplier's zip code
* **City**
* **Province**
* **Contact Person:** name of the primary contact person for the supplier
* **Phone:** reference phone number
* **Email (optional)**: vendor email
* **Notes (optional)**: notes and details about the vendor that may be useful

|              |                                |                                   |          |             |          |              |                    |               |                      |                      |
| ------------ | ------------------------------ | --------------------------------- | -------- | ----------- | -------- | ------------ | ------------------ | ------------- | -------------------- | -------------------- |
| **Name**     | **Currency (EUR, USD, GBP..)** | **Country code (US - IT - CN..)** | **Road** | **zipcode** | **City** | **Province** | **Contact Person** | **Telephone** | **Email (optional)** | **Notes (optional)** |
| Supplier 001 | EUR                            | IT                                | Street 3 | 50125       | Milan    | MI           | Jhon doe           | +362515428    |                      |                      |
| Supplier 002 | PLN                            | PL                                | Street 4 | 50124       | Wasrsaw  | MZ           | Jane Doe           | 63258855      |                      |                      |

### Bulk Upload -Bundled Products <a href="#prodotti-in-bundle" id="prodotti-in-bundle"></a>

A bundled product is one that contains multiple units of the same article, in this tab you can update the bundle quantity of your products in bulk (by ASIN or SKU)

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FRW2q4cS2wq06rQPaJ4jZ%2Fimage.png?alt=media&#x26;token=28e1e481-650f-4222-94ae-92371bb7c328" alt="" width="563"><figcaption></figcaption></figure>

It is possible to download different templates for uploading data:

* **Bundle Products Template**: contains only the headers and to be filled in line by line by the user.
* **Current Bundle Product Template: i**ncludes the currently set bundle quantity for your products

All templates contain the following information that must be filled in line by line:

* **Product \[sku or asin]:** Amazon product identifier
* **Bundle Quantity** - the quantity of bundles currently set on those products

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FLnaXVE9dB9IsL4F39KvL%2Fimage.png?alt=media&#x26;token=899d68b9-c83d-4725-94b5-d71e5a4f7894" alt=""><figcaption></figcaption></figure>

### Bulk Upload -Ordered Products <a href="#prodotti-ordinati" id="prodotti-ordinati"></a>

In this tab you can upload and indicate in bulk the ordered products

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FNj3wxqBNTaPmP1wqRi8F%2Fimage.png?alt=media&#x26;token=70800720-77a8-4045-8eb3-eee5e57223af" alt="" width="563"><figcaption></figcaption></figure>

It is possible to download the template for uploading the data:

* **Ordered Products Template**: contains only the headers on the **Product \[sku or asin]** i.e. the Amazon identification code of the product

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2F1MKCZ7IaVcuhpqfew6bJ%2Fimage.png?alt=media&#x26;token=3abbd027-0543-4b08-ad23-8af8d3fb18bf" alt=""><figcaption></figcaption></figure>

## Bulk Upload -Stop Supply Products

In this tab you can indicate the products (ASIN or SKU) for which you want to interrupt the bulk supply.

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FEYS2BpQfaZM1stz0LAal%2Fimage.png?alt=media&#x26;token=7b875a7f-9eb7-4ba7-b3b8-31c99127f1de" alt=""><figcaption></figcaption></figure>

You can download the data upload template.

* **Stop-Supply-Template** : contains only the headers.

| Textproduct \[SKU or ASIN ] |   |   |
| --------------------------- | - | - |
|                             |   |   |

### Bulk Upload -Merge Products <a href="#unisci-prodotti" id="unisci-prodotti"></a>

In this tab, you can merge products in bulk.

Select a main product and the products to merge into it.

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FOjYeQWfjMZJlmmno7G9B%2Fimage.png?alt=media&#x26;token=912e7929-012d-48e8-98e2-4e3d7864d8bc" alt="" width="563"><figcaption></figcaption></figure>

It is possible to download the template for uploading the data:

* **Template-Union-Products** : contains only the headers to be filled in

| Main SKU\* | Linked SKU 1\* | Linked SKU 2 \[opztional] | Linked SKU 3 \[optional] | Linked SKU 4 \[optional] |
| ---------- | -------------- | ------------------------- | ------------------------ | ------------------------ |
|            |                |                           |                          |                          |
|            |                |                           |                          |                          |
|            |                |                           |                          |                          |

### Bulk Upload -Packing Templates <a href="#template-di-imballaggio" id="template-di-imballaggio"></a>

In this tab, you can update the packing details of your products in bulk (by ASIN or SKU).

These are pre-built boxes with specific dimensions and weights that you can use when creating your purchase orders and shipments to Amazon.

<figure><img src="https://1934063593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB1lh8K0245IRSswKNrdg%2Fuploads%2FH4P6e1IG4Dc04RSo3OPN%2Fimage.png?alt=media&#x26;token=f0db2c3b-a92d-4893-b2ad-2164c4a9384c" alt="" width="563"><figcaption></figcaption></figure>

It is possible to download different templates for uploading data:

* **Packing Template** : contains only the headers and to be filled in line by line by the user.
* **Existing packing templates:** the list of all existing packaging templates

All templates contain the following information that must be filled in line by line:

* **Product \[sku or asin]:** Amazon product identifier
* **Name** - the amount of bundles currently set on those products
* **Unit of Measurement - 0 = Metric (cm-Kg) or 1 = Imperial (in,lb)**: unit of measurement in centimeters and kilograms (metric system) or in inches and pounds (Imperial)
* **Units per box:** quantity of products in the box
* **Box weight:** weight per box
* **Box length** : length
* **Box width**: depth
* **Box Height**: height
* **Prep by - SELLER or AMAZON:** shows who prepares the products, the seller or Amazon
* **Label by - SELLER or AMAZON :** indicates who labels the products, the seller or Amazon
* **Default 0 = NO - 1 = YES** : indicates whether preparation is required or not

<table><thead><tr><th></th><th></th><th width="152">Units of Measurement</th><th></th><th></th><th></th><th></th><th></th><th></th><th></th></tr></thead><tbody><tr><td><strong>Product [sku or asin]</strong></td><td><strong>Name</strong></td><td><strong>Units of Measurement</strong></td><td><strong>Box weight</strong></td><td><strong>Box length</strong></td><td><strong>Box width</strong></td><td><strong>Box height</strong></td><td><strong>Prep by - SELLER or AMAZON</strong></td><td><strong>Label by - SELLER or AMAZON</strong></td><td><p><strong>Default</strong></p><p><strong>0 = NO</strong></p><p><strong>1 = YES</strong></p></td></tr><tr><td>ASIN 96451</td><td><p>Box 150pcd</p><p><br></p></td><td>0</td><td>150</td><td>30</td><td>50</td><td>50</td><td></td><td></td><td>1</td></tr><tr><td>ASIN 4527</td><td>BOX 100pcs</td><td>0</td><td>100</td><td>20</td><td>50</td><td>50</td><td>SELLER</td><td>SELLER</td><td>0</td></tr></tbody></table>