Full write-off from the warehouse and posting of goods via excel file

[quote] Filonenko Sergey Yurievich Client wrote: I need to make a complete write-off of goods from the warehouse and then upload the posting through excel files. [/quote] Good morning. In general, you can export the balances to a file, then upload this file to the basket for decommissioning - only those that are in stock will be debited. [quote] Filonenko Sergey Yurievich Client wrote: It was not possible to write off products https://drevojelaniy.crm-onebox.com/admin/shop/storage/outcoming/ gives error https://prnt.sc/uua7yo [/quote] maybe just in the cart for writing off there were also goods that are not in stock, because adding a product to the cart by default, the quantity for it will be 1. Use the method above. [quote] Filonenko Sergey Yurievich Client wrote: The file also failed to receive new products via Excel, it gives an error https://prnt.sc/uua8b8 Uploaded Excel files to the file sharing service for posting https://ru.files.fm/u/5eqm8yxf [/quote] judging by what files you added to the file hosting service, it won’t work to post, or rather, add goods to the basket will not work, since you need a file in the xls format for import and the header of the uploaded file should have the following fields: https://crm-onebox.com/ru/support/sklad/1786-zagruzka-fayla-s-minimalnim-rezervom/ This is a cap for both posting and debiting

Made unloading a file (exporting the rest to a file). How can I upload it to the waste basket? I did not find a menu / button to upload a file

[quote] Filonenko Sergey Yurievich Client wrote: Made unloading a file (exporting the rest to a file). How to upload it to the write-off basket? I did not find the menu / button to upload the file [/quote] Yes, in the write-off section, there really is no possibility of loading from a file. You may be more suited to a recount mechanism. What you need to do the following steps: 1. Unload all the necessary balances to a file. In fact, we only need to get a list of such goods that are in stock. 2. In the file, in the balance column, put 0 for all products 3. In the inventory basket, load this file with a header according to https://crm-onebox.com/ru/support/sklad/1786-zagruzka-fayla-s-minimalnim-rezervom/ 4. You will get as a result that in the inventory basket there will be only goods that are in stock, all these products will be forced to be set to 0, when the inventory is carried out, the system will see that the new quantity is zero, but there is a certain number in the warehouse. quantity, therefore, will write off these goods from the warehouse. Why will there be a button at the bottom of the page http://i.imgur.com/OeGfifg.png

"In the file, in the column of balances, all products are put down 0" what is the name of this column?

In your case count

[quote] Shcherbatykh Ivan Alexandrovich Employee wrote: In your case count [/quote] I don't have such a column in the file https://prnt.sc/uuknra

[quote] Filonenko Sergey Yurievich Client wrote: Shcherbatykh Ivan Alexandrovich Employee wrote: In your case, count, I don’t have such a column in the file https://prnt.sc/uuknra [/quote] Of course not, you unloaded from the leftovers. you yourself need to delete unnecessary columns in the export file, and for the remaining ones, specify just such names as I showed you. Save the file and upload it to inventory. Undoubtedly, what I described to you will help you to easily load goods into warehouse baskets in the future, but, sorry, I missed an important point that will suit you in this case, namely http://i.imgur.com/qWygHRL.png

[quote] Shcherbatykh Ivan Alexandrovich Employee wrote: Sergey Yuryevich Filonenko Client wrote: Ivan Aleksandrovich Shcherbatykh Employee wrote: Sorry, I missed an important point that will suit you in this case, namely http://i.imgur.com/qWygHRL.png [/quote] That's exactly what I did, I clicked "add all products available in the warehouse", but I did not find the button to write off everything that is available in the warehouse!

Everything that is added to the basket http://i.imgur.com/KEc9UoU.png is written off

Did you succeed? Do you need more help with this request? Can you mark the completion?

yes, close it. Thanks!

the only problem. that when uploading the file, the numbers (number of goods) from the Count column were not pulled up https://prnt.sc/uuwqkq loaded into the cart just a few for each product had to manually

ok I'll check next time. thanks, close thread

[quote] Filonenko Sergey Yurievich Client wrote: ok I'll check next time. thanks, close thread [/quote] I can not close the topic)) this feature is available to you - you need to mark one of the answers as correct