Import mapping
new

By Václav Rössler, 4 years ago

Hello, I need help with import mapping. I need to update the quantity in stock. Products that are not in stock are not in the import file. How to map the products that are in the database but missing in the import file, set the quantity to "0"?

By Petr Hucik, 4 years ago

Unfortunately that's not possible. The module touches only the records that are specified in the input XML file.

You can, however, execute mass update prior the import, and set all quantities of all products to zero. I know it's not ideal solution, but it's the only one I can give you right now.

I will try to come up with solution for this (quite common) problem in the next release.

By Václav Rössler, 4 years ago

Yes, I've solved it so far, but this is how the whole warehouse is at zero for a few minutes. If I can still recommend, it would also be appropriate for the import to be linked to individual suppliers.

By Petr Hucik, 4 years ago

You can do this:

  1. create new date Custom field in product
  2. during import, update this custom field value to current date
  3. after import finished, you can run mass update, and update only those records with custom field value older than an hour or so

I know this is still not ideal, only a workaround. But at least the warehouse won't be zeroed for a few minutes.