1b.app
Link copied -

File upload with minimal fallback

Answers:

file: xls
Table header fields:
amount - quantity for the minimum reserve
barcode — barcode of goods in stock
productname - product name
price - product price
currency - currency
warranty - warranty
serial - serial number
shipment - batch code
tax - product tax
count - number of postings
article - article
Productid — product ID in the box
code1c - external identifier (used to search for a product)
custom_[key] - add. warehouse field (instead of [key] you need to specify the key of the additional field to the warehouse, without brackets)
06.10.2020, 13:37
Original comment available on version: ru

Specify a header from the above fields in the file.
The system searches for products by article, productid or code1c - it's better to leave only 1 column in the file. And in general, it is better to remove unused (empty) columns from the file, just do not specify them in the file, for example, the same currency or a barcode.
amount - for reserve only
the same header is used for posting, only you need to specify the number as - count
06.10.2020, 13:42
Original comment available on version: ru

It doesn't work with such columns http://joxi.ru/52aXbdXTk0EBnm
06.10.2020, 14:34
Original comment available on version: ru

I’m not sure about the RRP - you absolutely don’t need it, as well as the price in general, as well as the currency. I do not have this field in the description. Try to remove it.
The task of the minimum reserve is to report when the quantity of goods in the warehouse becomes less than the specified quantity of the minimum reserve.
When importing this file, the price of the goods is not modified in any way.
In fact, the following number of columns is enough for you:
Name for visual perception, product id - for product identification when importing a file and amount - for specifying the minimum quantity. After import in the product card in acc. tab, a record is created with the given number.
06.10.2020, 14:51
Original comment available on version: ru

import does not work. Nothing happens after download
06.10.2020, 21:30
Original comment available on version: ru

Are you sure the file is xls?
try to leave a smaller number of goods in the file, for example, 3 positions.
Can you show a screenshot of the header of the table being loaded?
07.10.2020, 09:20
Original comment available on version: ru


Farkhshatov Rodion Client wrote:
It doesn't work with such columns http://joxi.ru/52aXbdXTk0EBnm

here is the screenshot
xls file
07.10.2020, 11:30
Original comment available on version: ru


Farkhshatov Rodion
Client wrote:
here is the screenshot

I already gave you what columns you need, there is no RRP, but you have it, judging by the screen. You can leave in the file:

Shcherbatykh Ivan Alexandrovich
Employee wrote:
Name for visual perception, product id - for product identification when importing a file and amount - for specifying the minimum quantity.
07.10.2020, 11:40
Original comment available on version: ru

it worked without rrs. So with this field does not allow the price to be loaded?
Not a single notification was received / failed.
The filter is poor.
In a good way, this section should be like the Products section with full filtering and a bulk action panel for changing the quantity.
07.10.2020, 11:59
Original comment available on version: ru


Farkhshatov Rodion
Client wrote:
it worked without rrs. So with this field does not allow the price to be loaded?
Yes, the system encountered an incomprehensible value in the file and did not load anything, since it could not identify the purpose of the column.

Farkhshatov Rodion
Client wrote:
Not a single notification was received / failed.
Yes, there is such a thing.

Farkhshatov Rodion
Client wrote:
In a good way, this section should be like the Products section with full filtering and a bulk action panel for changing the quantity.
Vanbox is constantly improving, perhaps such functionality will appear soon.
___________
If I helped you with this task, please note the implementation.
07.10.2020, 12:50
Original comment available on version: ru


Shcherbatykh Ivan Alexandrovich Employee wrote:
Yes, the system encountered an incomprehensible value in the file and did not load anything, since it could not identify the purpose of the column.

very strange, because in the video instruction, the file with exactly these fields
07.10.2020, 14:18
Original comment available on version: ru

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment