Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 VP-Cart 8.0 Hint''s and Tips
 How do you manage stock updates?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jack208
VP-CART New User

Malaysia
116 Posts
Posted - February 07 2016 :  05:08:58  Show Profile  Reply with Quote
Does anyone here uses the webstore as inventory control ie you have the actual quantity updated to your Item record, and on each order, deduct the qty sold (that''s the easy part).

When you restock, how do you add the restocked qty to the existing qty in the webstore database (beside manually editing each item)?

This can be further complicated when you have an inventory of say 1,000 items, and each restock you may be restocking selectively 200-300 items only.

Thanks in advance for any replies/suggestions/sharing. :)

carfin
VP-CART Expert

United Kingdom
948 Posts
Posted - February 08 2016 :  04:24:30  Show Profile  Reply with Quote
Hi Jack,

if an order is placed through the site, it will automatically adjust the stock available if you have xstockcontrol in CartSetup set to Yes which is the way our site is set up. However, we have thousands of products which we also sell via telephone, sales rep calls and fax. Every couple of hours I produce a csv file from our accounting software which I then upload to our site via the Bulk update opton. Simple and quick and although it is not 100% real time stock level it works really well for us.
Perhaps you could create an excel file with the stock code and stock level for all your products (just use the products table export facility) then it can easily be updated manually and saved as a CSV file to import to your site.

Any questions, just ask :)

Carrol
www.deanston-electrical.co.uk
Go to Top of Page

danielrichardson
VP-CART Super User

Australia
276 Posts
Posted - February 08 2016 :  10:22:57  Show Profile  Reply with Quote
Awesome Carrol, nice tutorial from you. Thanks.
Go to Top of Page

serjtankian
VP-CART Super User

Armenia
378 Posts
Posted - February 09 2016 :  12:48:06  Show Profile  Visit serjtankian's Homepage  Reply with Quote
@Carrol

Can you show me a sample of the csv file? maybe just a simple screenshot?

Thanks






*serj*
Go to Top of Page

jack208
VP-CART New User

Malaysia
116 Posts
Posted - February 09 2016 :  16:42:12  Show Profile  Reply with Quote
Hi Carrol, thanks for your reply. That''s more or less how we can working around the inventory control now though not exactly in the same approach as yours. We''ve the Phone Order module in place and use that to handle non-web orders (we do not have other retail buying points so our situation is somewhat simpler than yours).

Do you also export the orders from the webstore into your accounting system? Coz that''s the next phase we are looking into doing and would appreciate any pointers from you - or anyone else - who have done something similar.
Go to Top of Page

carfin
VP-CART Expert

United Kingdom
948 Posts
Posted - February 10 2016 :  04:47:48  Show Profile  Reply with Quote
@ serj
Here is a sample from my csv upload file

http://www.deanston-electrical.co.uk/ScShotcsv.htm


@jack
our web orders are manually entered into our accounting software by our office staff.
Yes it''s extra work but it allows us to keep control of the ordering process and it''s a nice change from decyphering the hand written faxed orders. We get about 10 to 20 orders a day through the web site which at the moment is manageable (although some orders have over 60 items on them)
I think in future we will get it all integrated but that is for management to decide.

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page

squirrel
VP-CART New User

USA
73 Posts
Posted - February 12 2016 :  04:12:10  Show Profile  Reply with Quote
@jack

I use the xstockcontrol option too. However, I also have QuickBooks integrated.

Thanks,
Daniel
Go to Top of Page

aprilynm
Starting Member

USA
33 Posts
Posted - February 16 2016 :  11:05:09  Show Profile  Reply with Quote

Daniel,

Do you use T-Hub to integrate with Quickbooks? If not, may I ask how you manage this? It is one of the next steps we want to tackle.

Thanks,


Aprilynm
Edited by - aprilynm on February 16 2016 11:06:01
Go to Top of Page

squirrel
VP-CART New User

USA
73 Posts
Posted - February 17 2016 :  05:21:46  Show Profile  Reply with Quote
@Aprilynm,

I used CartSpan (http://www.cartspan.com/)''s services to integrate QuickBooks and everything was well taken care for me :)

Not quite sure about T-Hub. But, it seems that VPASP has a page for this http://www.vpasp.com/virtprog/info/faq_accounting.htm.

Do keep us posted if you tried integrating with T-Hub and post your experience here.

Thanks,
Daniel
Edited by - squirrel on February 17 2016 05:26:38
Go to Top of Page

ils5gvl
Starting Member

USA
15 Posts
Posted - March 08 2016 :  12:24:42  Show Profile  Visit ils5gvl's Homepage  Reply with Quote
After reading this post I contacted Scott at CartSpan to see if they could do the stock/inventory and price synchronization in addition to the order imports to QB, etc. It turns out that they can do it but only on MySQL and not on SQL Server. He is primarily coded for PHP. I''m not exactly clear on why it won''t work but he looked into it and respectively declined to do the necessary development work for a pretty substantial price. Scott is a really nice guy and easy to reach which is in stark contrast to Atandta (T-Hub). We''ve been using T-Hub for order processing into QuickBooks for over 2 years now. It''s nearly impossible to reach anybody there.

I would love to hear from anybody who has success with integrating VPASP with QuickBooks for inventory and pricing. It''s a nightmare to administer with a large range of products.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty