|
Neilt
Starting Member
44 Posts |
 Posted - December 03 2009 : 10:16:10
|
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.
Neil
|
|
All Forums
Bulk Import does not populate cdateadded
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
