Before you map your source file's inventory field to your shop's inventory in the Field Mapping, you may want to know how Syncee really treats these values.

Syncee only works with numbers when it comes to inventory quantity.

When the source file contains whole numbers, obviously that number will appear in your store. For example:
 0 = 0
10 = 10
324 = 324
-1 = -1
-2 = -2 etc.

As Shopify only accepts whole numbers for this value, Syncee rounds the decimal values to whole numbers in the inventory quantity field. For example:
0.2 = 0
0.7 = 1
2,5 = 3
1,456 = 1

We know that sometimes the suppliers use, for instance 1,456 instead of 1456, so Syncee has a solution for this. In the field Mapping step, connect the inventory quantity to the appropriate Shopify field and click on the wheel icon next to it. You can modify the source file value with the Select Only (REGEX) field.

(([\d])?,)?([\d]+)|||$2$3

If you use this operation, Syncee will upload 1456 as inventory quantity to your shop, instead of 1.

If you need help with REGEX, feel free to contact the support staff.

Syncee automatically deletes information, other than numbers from this field. For example 23 qty=23

In case of price, there are also obvious values, such as:
empty=0 (In case of 0 price, Syncee doesn't upload products or variants)
-1 = 0 (In case of 0 price, Syncee doesn't upload products or variants)
0 = 0 (In case of 0 price, Syncee doesn't upload products or variants)
1 = 1
1.00 = 1.00
2.34 = 2.34

We automatically modify the following values:
32,5 = 32.5 (converts comma to decimal point)

32.5 USD = 32.5
USD 32.5 =32.5
$32 = 32

Syncee deletes values other than numbers from the fields, because Shopify only accepts numbers in the Price field.

It is important to know that Syncee first does the modifications mentioned above and only after this converts the currency, adds price margin or rounds the price.

Let us know if you need more information.

Did this answer your question?