Pleb
Starting Member
6 Posts |
Posted - January 07 2004 : 00:51:13
|
Rapheal my saviour?. If what you speak of eliminates the work arounds I've used for 2 years - I'll love you long time.
Next bulk import is due in two weeks. Hope you've found it, but your solution may not be mine.
My particular problem with bulk imports is getting one part number to shoot off to 1 or more SubCategories which in themselves are under different main Categories.
Yeah, VPASP can do it via it's web page admin console, but who has the time for that unless you have less than 50 products. Nothing beats a good text file import. And with the cart's mdb sitting on our hosting company's server, we can't easilly do the alterations we have to do daily.
Therefore, our main database is kept in another "MS Access" format and from that we run queries to produce price lists, csv files for imports to our accounting program, and other activities. We can't use VPASPs mdb file as we have other products that aren't in the cart - nor do we want the risk of them accidently apppearing in the cart.
My solution involves adding -01, -02, -03 etc (via Excel) to each part - to make the same part appear a different one. Then, with their relative 'ccategory' number assigned - the import file is ready.
Before import, I empty the PRODUCTCATEGORIES TABLE using aspAccessEditor. I've end up with say 4000 products in the cart when I only have 1500. But it works and my boss gave me a bonus at Xmas to buy some steak for the kids.
You'll hear from me in this thread if your way works. It will save so much time. Roll on technology. Only a few years ago these carts for plebs didn't exist.
Pleb
|
|
|