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

• FBM shipping cost per order

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.

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)

• 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

Example of template compilation:

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:

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:

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:

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

Example of filling out the template:

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: