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:
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.