VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Problems and bugs
 Bulk Import does not populate cdateadded
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

44 Posts

Posted - December 03 2009 :  10:16:10  Show Profile  Reply with Quote
I found that when using the bulk import (i.e. csv files) to add new products, no value was being written to the cdateadded column in the products table.

This was preventing products appearing in our 'latest products' section.

I forced the writing of a value as follows:

Within shopa_import.asp

Find: Sub GetExistingRecord (catalogid)
Within the section that starts: "If Doupdate="" then"
add the following after: "cntnew=cntNew+1" (around Line 503)

'force the writing of a value to cdateadded for products added via the bulk import
'VPASP as standard does not include this
If tablename = "products" then objRS("cdateadded") = now()

(i.e. this additional code should appear before the line "If ResultsFlag=Yes then")

Hope this is helpful.


  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000