Bulk Upload (Profit Tool)

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

Bulk upload stock 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

Bulk upload unit product costs

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.

Bulk upload external expenses

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.

Bulk upload product short names

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

FBM Shipping Costs of Products

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…)