Bulk Upload (Accounting Tool)

You can access this section from the left menu Accounting >> Bulk Upload.

In this section, you can upload via Excel file information regarding:

• product VAT rates

• external sales

• product values

Bulk upload product vat rates

You can access this section from the left menu Accounting >> Bulk Upload >> Product VAT rates.

In this section you can assign VAT rates to your products in bulk.

You can download various templates for data upload:

• Empty VAT rates Template: contains only headers and is to be filled in line by line by the user.

• Current VAT rates Template: in addition to the headers, this template already contains all the VAT rates currently associated to the products

Then you will need to fill in the template with the following information for each product:

• product: ASIN or SKU code of the product

• country code: ISO code of the country (e.g., IT, DE, FR...)

• rate: 10% or 0.1

Once you have filled out the file, save it and upload it in the "Select File" field.

Check the import result in the notification center.

Bulk upload external sales

You can access this section from the left menu Accounting >> Bulk Upload >> External Sales.

In this section you can upload in bulk sales, refunds and invoices from channels that are not currently integrated with ZonWizard.

First, download the template by clicking on the download icon.

Then, you'll need to fill out the template with the following information for each sale:

• Payment date: in Excel date format

• Order ID: order identification code

• Product ID: unique product code

• Quantity: number of items sold

• Product price: total price of products including VAT

• Shipping price: shipping price including VAT

• Currency: ISO currency code (e.g., EUR, GBP, USD).

• Shipping country code: ISO code of the departure country of shipment (e.g., DE, FR, ES)

• Arrival country code: ISO code of the destination country of the shipment (e.g., DE, FR, ES)

• Marketplace: name of the marketplace, only one of the following supported values can be entered:

  • Shopify

  • ManoMano

  • Etsy

  • WooCommerce

  • Zalando

  • Leroymerlin

  • Decathlon

  • Prestashop

  • Other

If there's an invoice associated with the sale, also fill in the following optional fields:

• Invoice number: invoice identification number

• B2C or B2B: 0 for private customers or 1 for business customers

• VIES invalid or valid: 0 for customers with VAT numbers not registered with VIES or 1 for VAT-registered customers

The following table provides an example of compilation

Once you've filled out the file, save it and upload it in the "Select File" field.

Check the import result in the notification center.

Bulk upload product values

You can access this section from the left menu Accounting >> Bulk Upload >> Value of Products Transferred.

Here you can assign a value to your products in bulk. This value will be used to calculate the monetary value of goods transferred between Amazon warehouses.

Assign Product Value as Percentage

For an approximate assignment of product value, you can indicate the value as a percentage of the selling price.

To do this, enter a percentage in the input field and click the "Assign to all products" button.

Assign Product Value from Profit Tool

If you have already assigned the cost of products within the Profit tool, you can retrieve the value of the products based on this.

To do this, simply click the "Update from profit tool" button.

Assign Product Value from Excel

You can download various templates for data upload:

• Current Product Value Template: in addition to the headers, this template already contains all the VAT rates currently associated to the products

• To Be Configured Product Value Template: in addition to the headers, this template already contains only the SKUs to which a value has not yet been assigned.

Then you will need to fill in the template with the following information for each product:

• product: ASIN or SKU code of the product

• Product Value: the value in EUR to be assigned to the product

Check the import result in the notification center.