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

Product ASIN

Country

VAT Rate

ASIN__12345

ES

10%

ASIN__12346

IT

10%

ASIN__12347

DE

7%

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

Payment date

Order ID

Product ID

Quantity

Product price (incl. VAT)

Shipping price (incl. VAT)

Currency

Shipping country code

Arrival country code

Marketplace

Invoice number

B2C or B2B (0 or 1)

VIES invalid or valid (0 or 1)

2023-12-01

123.456.789

SKU1

1

20.30

4.55

EUR

IT

DE

Shopify

INV-2023-011

1

1

2023-12-02

123.456.790

SKU2

1

-35.30

0.00

EUR

IT

FR

Shopify

CN-2023-002

1

1

2023-12-03

123.456.791

SKU3

1

22.55

7.40

EUR

IT

FR

Shopify

2023-12-04

123.456.792

SKU4

1

11.23

4.55

EUR

IT

ES

Shopify

INV-2023-012

1

1

2023-12-05

123.456.793

SKU1

1

56.30

5.30

EUR

IT

DE

WooCommerce

2023-12-06

123.456.794

SKU2

2

-34.20

7.40

EUR

IT

FR

WooCommerce

2023-12-07

123.456.795

SKU3

1

12.50

4.55

EUR

IT

FR

WooCommerce

INV-2023-013

1

0

2023-12-05

123.456.793

SKU4

1

120.00

5.30

EUR

IT

ES

WooCommerce

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.

If the external sales you inserted have a reduced rate (e.g., for food or pharmaceutical products), you can set the product rate in the Reduced Rates section.

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.

If you have already configured the purchase cost of the products in the Profit Tool, the value of the products will be automatically assigned based on that.

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

Product [sku or asin]*

Product Value [EUR]

SKU_12049

€ 5.84

SKU_14081

€ 3.18

SKU_1567

€ 5.29

SKU_18301

€ 10.00

SKU_20721

€ 12.78

Check the import result in the notification center.

Last updated