Virtuemart Homework is Microsoft Access Application for Virtuemart Component. I develop this application for my own purpose and objectives. I am sharing this applications to virtuemart lovers. The concept is to directly connect with Virtuemart mySQL database tables. Via MySQL ODBC connector.
Introduction Video of VMHomework
VMHW, is small Microsoft access application, it directly connect with mysql database and cling with your Virtuemart Data Fields and bring all your shop data into a desktop application format. It will able you to edit/add new categories and products data into virtumart core tables faster than working at web browsers, hence all changes at your site pages will be made as you type.
VMHW able you to quickly add new categories, add new products edit existing products data, prices, discount and all other most important task in a desktop application format. No Need to login at admin panel just for one record change.
Just create a system dsn vmhw and select database of your virtumart website. Run this application and explore your shop data right in a desktop application format, feel your shop right on your finger tips and enjoy quick data saving / editing /adding from manufacture to product sorting
You do not have to install any thing at your joomla website, It just need Microsoft Access 2007 and mysql odbc connector installed at your machine.
Complete guide how to use this application which will save your time and will help you to keep your virtuemart website products and categories updated.
Add New categories Edit existing categories important fields
Add New Products, with prices, discounts, tax rates, manufactures, place products in related categories
Add New manufactures, Get Products of selected manufacture, Edit them in excel style list
Print Invoices, Customers Data, Print Products List of entire shop or just one category
And lot of more you want ….. just pay some time to see tutorial video
What can this application do?
- 1. Add New / Edit Categories. (No Wait just add new add new add new …..)
- 2. Quick Sort Categories List.
- 3. Publish/Unpublish/,Flypage /Browse page.
- 4. Get all products of any single categories and then edit the products, prices, adjust discounts, quick sort products, publish/unpublish, Availability, Stock Update. In excel list style.
- 5. Print All Shop products data in Category wise, Print Products of a selected category.
Add New/Edit Products.
- 1. Quick sort products in a category.
- 2. Add New/Edit Products and putting in desire Category from list ((No Wait just add new add new add new …..)
- 3. Change/Shuffle Products to another category.
- 4. Product Regular Prices, Prices for each shopper group.
- 5. Select manufacture and vendor for product.
- 6. Edit/update Stock, Height, Weights, Length, Unit.
- 7. Create/edit Product Attributes.
- 8. Product Short Descriptions in RICH Text Format, Product Detail Description Rich Text Format.
- 9. Feature Product, Selected Related Products.
- 10. Products Discount Attachment, Discount in Number and Percentage.
- 11. Select Manufacture and then get products of related manufacture & Edit / update products field just like excel,
- 12. Order Main Page, Filter Order by customers & Print, Filter order by status & Print, Print Invoice/Order, Print Customer Data with complete Banking information.
- 13. Edit/Add New Shopper Groups,
All you will do above in one window operation. No Need to install any component/modules or plug-in into your joomla website.
Just see the below two videos. You will need following your machine.
- 1. Must have access 2007 in your machine
- 2. Must install MySQL ODBC connector, download free from (www.mysql.com )
- 3. Follow the Video “How to create ODBC connection with your mysql server” http://youtu.be/STsNeqLBkSM
- 4. Application Facebook Page: http://www.facebook.com/groups/219152821439015/
- Application Working Demo Video: http://youtu.be/cUdeCzHHSSo
- 6. Application Web Page: http://www.yazinc.net/index.php?option=com_content&view=article&id=126:vm-homework-&catid=53:applications&Itemid=203
Please Use Freely with Virtuemart 1.1.4 or 1.1.9 and donate to this project so I can add more option for virtuemart users and start same editing application for Joomla CMS.
Insturctions: How to creat DSN to able VMHomework to link with mysql/Virtuemart Database tables
Video: How this application manage products and categories images
You can also use JOLE (joomla offline editor) which developed on same concept and work with Joomla CMS.