Bulk Upload (Profit Tool)
Last updated
Last updated
You can access this section from the left menu Profit >> Bulk Upload.
In this section, you can upload via Excel file information regarding:
purchase cost of product stocks
unit purchase cost of products
short names of products
external expenses
FBM shipping costs
In this section, you can upload information related to the cost of product stocks arriving at warehouses from which shipments to end customers will depart.
To learn the details of how the purchase costs are assigned, visit the profit - product details - assign purchase costs section.
If you want to directly upload the unit cost of products without entering all the stock information, see the section bulk upload unit product cost.
You can download various templates for data upload:
Empty Stock Template: contains only headers and is to be filled in line by line by the user.
Precompiled Stock Template with SKU: in addition to the headers, this template already contains all the SKUs present in the catalog.
Precompiled Stock Template with ASIN: in addition to the headers, this template already contains all the ASINs present in the catalog.
To Be Configured Stock template: in addition to the headers, this template already contains only the SKUs to which a cost has not yet been assigned.
Existing stock Template: in addition to the headers, this template already contains all the stocks previously uploaded.
All templates contain the following information to be filled in line by line:
Product [SKU or ASIN]: product identification code
Arrival Date [yyyy-mm-dd]: date of arrival at warehouse in format [yyyy-mm-dd] (e.g., 2024-03-20)
Automatic Remaining Units [0=No - 1=Yes]: 1 if you want ZonWizard to calculate the warehouse remainders and 0 if you prefer to indicate them manually
Warehouse Remainders [optional]: Number of products still in stock upon arrival of new stock, this value is not required if you set 1 to the previous value, or if you want to ignore the previous reminder
Production Cost: Cost of stock production
Shipping Cost: Cost of shipping the stock from the supplier to the warehouse from which shipments to customers depart
Customs Duties [optional]: costs for customs clearance
Other Costs [optional]
Quantity: Number of products shipped
All costs must always be indicated net of VAT. Only for sellers under the flat-rate tax scheme should costs be indicated including VAT.
By editing and re-uploading a previously uploaded file, you can modify the previously entered data.
Example of template compilation:
Product [sku or asin]* | Arrival Date [yyyy-mm-dd]* | Automatic Remaining Units [0=No - 1=Yes] | Warehouse Remainders | Production Cost* | Shipping Cost* | Customs Duties | Other Costs | Quantity* |
SKU_12049 | 2020-12-08 | 0 | 234 | € 7,653.25 | € 3,478.75 | € 683.00 | € 695.75 | 2500 |
SKU_12050 | 2021-08-08 | 1 | 0 | € 6,957.50 | € 3,478.75 | € 433.00 | 2500 | |
SKU_14081 | 2023-10-16 | 0 | 23 | € 590.00 | € 0.00 | 500 |
In this section, you can upload the purchase cost of your products, simply specifying a product identifier and the unit cost. This is a simplified way of uploading product costs compared to the section Bulk Upload Stock Costs.
To learn the details of how the purchase costs are assigned, visit the profit - product details - assign purchase costs section.
You can download various templates for data upload:
Product Unit Cost Template: contains only headers and is to be filled in line by line by the user.
Precompiled Unit Cost Template with SKU: in addition to the headers, this template already contains all the SKUs present in the catalog.
To Be Configured Unit Cost Template: in addition to the headers, this template already contains only the SKUs to which a cost has not yet been assigned
Current Unit Cost Template: in addition to the headers, this template already contains all the product costs as of today's date
All templates contain the following information to be filled in line by line:
Product [sku or asin]: product identification code
Unit Cost: purchase cost of the single product
Example of template compilation:
Product [sku or asin]* | Unit Cost* |
SKU_12049 | € 5.84 |
SKU_14081 | € 1.18 |
SKU_1567 | € 5.29 |
SKU_18301 | € 24.00 |
SKU_20721 | € 16.78 |
All costs must always be indicated net of VAT. Only for sellers under the flat-rate tax scheme should costs be indicated including VAT.
Uploading this file assigns the unit cost of products starting from today's date. For products to which no unit cost has ever been previously assigned, the cost will also be associated with all orders before today's date.
In this section, you can upload information related to external expenses.
To learn the details of how external expenses work, visit the profit - external expenses section.
You can download various templates for data upload:
Empty Expenses Template: contains only headers and is to be filled in by the user line by line.
Existing Expenses Template: in addition to the headers, this template already contains all the external expenses previously uploaded in the software.
All templates contain the following information to be filled in line by line:
Date [yyyy-mm-dd]: date of expense or start of recurrence
Recurrence: select whether the expense is one-time (0) or the recurrence frequency
0 = no
1 = daily
2 = weekly
3 = monthly
4 = annual
Until [yyyy-mm-dd]: end date of recurrence
Category: Expense category
Description: Expense description
Product [optional]: product identification code
Marketplace [optional]: marketplace name
Amount: of the expense or single recurrence
Example of template compilation:
Date [yyyy-mm-dd]* | Recurrence | Until [yyyy-mm-dd] | Category* | Description* | Product[SKU] | Marketplace | Amount* |
2023-07-20 | 3 | Social | YouTube Campaign | € 123.00 | |||
2023-08-16 | 3 | 2023-11-13 | Bills | Internet | € 45.00 | ||
2023-08-18 | 3 | 2023-11-23 | Logistic | Warehouse | Amazon.it | € 110.00 | |
2023-08-20 | 3 | 2023-11-23 | Software | ZonWizard | € 7.75 | ||
2023-09-21 | 3 | Generic | Phone bill | € 15.00 |
All costs must always be indicated net of VAT. Only for sellers under the flat-rate tax scheme should costs be indicated including VAT.
In this section, you can upload short names to assign to your products.
To learn the details of how short names are assigned, visit the profit - product details - assign short name section.
You can download various templates for data upload:
Empty Product Names Template: contains only headers and is to be filled in line by line by the user.
To Be Configured Product Names Template: in addition to the headers, this template already contains all the SKUs that have not been assigned any short name.
Current Product Names Template: in addition to the headers, this template already contains all the catalog SKUs with the currently assigned short name.
All templates contain the following information to be filled in by the user:
Product [SKU]: product identification code
Short Name: product name
Example of template compilation:
Product [SKU] | Short Name* |
SKU_41628 | Size XL |
SKU_96451 | Red |
SKU_30255 | Blue |
SKU_1567 | 500ml |
SKU_96271 | 250ml |
In this section, you can upload shipping costs for products shipped with FBM logistics.
To learn the details of how FBM shipping costs are assigned, visit the profit - product details - assign FBM shipping cost section.
You can download various templates for data upload:
Empty FBM Shipping Costs Template: contains only headers and is to be filled in line by line by the user.
Precompiled FBM Shipping Costs Template: in addition to the headers, this template already contains all the SKUs managed in FBM.
Existing FBM Shipping Costs Template: in addition to the headers, this template already contains all the shipping costs of FBM products previously assigned.
All templates contain the following information to be filled in by the user:
Product [SKU]: product identification code
FBM Shipping Cost: amount of shipping cost in EUR currency
Marketplace: Name of the marketplace in text format (e.g., Amazon.it, amazon.fr…)
Example of filling out the template:
Product [sku or asin]* | FBM Shipping Cost* | Marketplace* |
SKU_14081 | € 4.40 | Amazon.it |
SKU_14081 | € 5.60 | Amazon.de |
SKU_14081 | € 6.30 | Amazon.co.uk |
SKU_14081 | € 5.40 | Amazon.fr |
SKU_14081 | € 4.90 | Amazon.es |
All costs must always be indicated net of VAT. Only for sellers under the flat-rate tax scheme should costs be indicated including VAT.
In this section, you can upload shipping costs for every order shipped with FBM logistics.
You can download various templates for data upload:
Empty FBM Shipping Costs by Order Template: contains only headers and is to be filled in line by line by the user.
Existing FBM Shipping Costs by Order Template: in addition to the headers this template already contains all orders for which an FBM shipping cost has already been specified.
All templates contain the following information to be filled in by the user:
Order ID: Identification code of the order for which you want to assign the FBM shipping cost
FBM Shipment Cost: amount of shipping cost in EUR currency
Example of filling out the template:
Order ID* | FBM Shipment Cost* |
123-456789-100 | € 7,00 |
123-456789-101 | € 5,50 |
123-456789-102 | € 6,50 |
123-456789-103 | € 5,40 |
123-456789-104 | € 5,90 |
All costs must always be indicated net of VAT. Only for sellers under the flat-rate tax scheme should costs be indicated including VAT.
