News:

Looking for documentation? Take a look on our wiki

Main Menu

Reconciling Whole Store Inventory by Category - Help!

Started by mikidudle, December 06, 2018, 23:50:40 PM

Previous topic - Next topic

mikidudle

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


diri

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.

Jörgen

#2
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

You can export and import csv files.

Jörgen @ Kreativ Fotografi

[edit, can not see how the line came alive, now it is correct :)]
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

GJC Web Design

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation