Author Topic: Reconciling Whole Store Inventory by Category - Help!  (Read 108 times)

mikidudle

  • Beginner
  • *
  • Posts: 8
  • A beginner
Reconciling Whole Store Inventory by Category - Help!
« 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


diri

  • Beginner
  • *
  • Posts: 46
Re: Reconciling Whole Store Inventory by Category - Help!
« Reply #1 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.

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 1794
    • Kreativ Fotografi
  • VirtueMart Version: 3.2.12
Re: Reconciling Whole Store Inventory by Category - Help!
« Reply #2 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

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.8.3
Virtuemart 3.2.12
Olympiantheme Hera (customized)

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 8556
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation