VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: mikidudle on December 06, 2018, 23:50:40 PM

Title: Reconciling Whole Store Inventory by Category - Help!
Post by: mikidudle on December 06, 2018, 23:50:40 PM
Hello,

Is there a way to print out every product in a category, or export all products in a category to a csv or text file?
My customer wants to do an inventory. He needs to reconcile the database with what is actually in his store, by category.
Any ideas?
Joomla 3.9.1
VM 3.4.2
url: hobbysmith.com
Win 7 Ultimate 64

Title: Re: Reconciling Whole Store Inventory by Category - Help!
Post by: diri on December 07, 2018, 05:18:04 AM
For a product like Virtuemart it is a shame but:

There is no functionality to export or import products.

It might be sufficient to go with mysql and / or phpmyadmin and some SQL to export what you need. Working with Excel or the like for inventory and update stock in VM is easy than.

Importing new products is another kind of animal ..., i.e. CSVI might be of help or you implement something for yourself.
Title: Re: Reconciling Whole Store Inventory by Category - Help!
Post by: Jörgen on December 07, 2018, 06:55:53 AM
Hell There are som trolls out there.
Hello, There are some tools out there.

I think Studio42 has some back end management tool not sure if that manages import en export.

This is what I use to get inventory lists from category, manufacturer etc:
https://www.daycounts.com/shop/virtuemart-2/advanced-inventory (https://www.daycounts.com/shop/virtuemart-2/advanced-inventory)

You can export and import csv files.

Jörgen @ Kreativ Fotografi

[edit, can not see how the line came alive, now it is correct :)]
Title: Re: Reconciling Whole Store Inventory by Category - Help!
Post by: GJC Web Design on December 07, 2018, 08:07:56 AM
https://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm has full export facilities