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.

Bulk upload stock costs

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.

Bulk upload unit product costs

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.

Bulk upload external expenses

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.

Bulk upload short names

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.

FBM Shipping Costs of Products

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.

FBM Shipping Cost by Order

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.