Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Make Update Of Product Inventory Rate Topic   - - - - -

 
  • lastpixel
  • Member
  • Trial users
  • Join Date: 25-Feb 16
  • 36 posts

Posted 27 February 2016 - 09:49 AM #1

I need an addon to update products inventory (quantity) by searching the product by sku or by name, with autocomplete suggestions, and in the input field of qty to add only qty which is on the invoice, and after pressing enter the amount introduced to be added (sum it up) to amount from database.

 

Example: If I have in database 5 pcs. and on invoice from my supplier I have 20 pcs., then after I complete the input field with 20 and pressing enter, the total amount from db will be 25.

 

The same if I want to decrease the qty in db (in this case the filled amount will be negative and will be subtracted from db)

 

Thank you, Josh.



 
  • BarryH
  • Senior Member
  • Members
  • Join Date: 03-Sep 07
  • 1459 posts

Posted 27 February 2016 - 09:59 AM #2

If you are familiar with Microsoft Excel and Access it is easy to create a DB that you export products from website to and create a simply update QTY Query then import it back to website. Once you have made it you can just use over and over.

 

This is how we handle say for example a particular manufacturer price increase, saves loads of time.

 

Regards

 

Barry


BarryH

 

CS-Cart v4.4.3 (Plus one being developed v4.5.2 SP2)
UK User


 
  • lastpixel
  • Member
  • Trial users
  • Join Date: 25-Feb 16
  • 36 posts

Posted 28 February 2016 - 11:31 AM #3

Thank you, but I don't want to use any other tools.