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
 Suggestions for future release
 Better Product Import Method		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

canadasurplus
Starting Member

Canada
11 Posts
Posted - November 21 2002 :  16:22:54  Show Profile  Visit canadasurplus's Homepage  Reply with Quote
We run the product import function daily to update our Online business with the prices and quantities in stock in our retail store.
We have attempted to do this on our server and since we have a large number of products it takes 30 minutes to 1 hour to complete and really slows down, or stops the shopping cart server.
So the better method is to download shopping400.mdb and run the import function on a local computer then upload the updated database.
However while we are updating shopping400 on a local computer customers are still shopping and when we upload the modified database it overwrites any orders that have been received during the update!

The only solution I can suggest would be to keep the products table outside of shopping400 so that the products could be downloaded, updated and re-uploaded without loosing any customer orders.

Bob

rodney
VP-CART New User

USA
75 Posts
Posted - January 22 2003 :  05:01:36  Show Profile  Reply with Quote
How many products do you have running in vpasp

Our Inventory module exports

ccode, cstock, cprice
and those are the only field I do a product import on

quote:

We run the product import function daily to update our Online business with the prices and quantities in stock in our retail store.
We have attempted to do this on our server and since we have a large number of products it takes 30 minutes to 1 hour to complete and really slows down, or stops the shopping cart server.
So the better method is to download shopping400.mdb and run the import function on a local computer then upload the updated database.
However while we are updating shopping400 on a local computer customers are still shopping and when we upload the modified database it overwrites any orders that have been received during the update!

The only solution I can suggest would be to keep the products table outside of shopping400 so that the products could be downloaded, updated and re-uploaded without loosing any customer orders.

Bob





-Rodney
Go to Top of Page

AJ
Starting Member

2 Posts
Posted - January 22 2003 :  11:08:58  Show Profile  Reply with Quote
Canada Surplus a.k.a. AJ

We have about 2300 products online. We update the price and stock for items in the product table. The main problem is not how long it takes but rather when it locks up.
Go to Top of Page

rksymons
Starting Member

10 Posts
Posted - February 03 2003 :  10:36:27  Show Profile  Reply with Quote
quote:
We have about 2300 products online. We update the price and stock for items in the product table. The main problem is not how long it takes but rather when it locks up.


What kind of server are you hosting on? I've only done one product import so far on a linux box with ChiliASP and MySQL, but...

...over 11,000 products only took a few minutes to import.

rks
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