Article Number: 304 | Rating: Unrated | Last Updated: Mon, Oct 5, 2015 at 5:16 PM
Purpose:
To identify the field labels for running ecommerce specific SQL scripts.
Solution:
The SQL Script Utility that installs with Counterpoint can be used to quickly adjust ecommerce items. There are several related KB articles about this, but here is a breakdown of the field names that can be used when scripting:
Field in CPSQL
Field name in database
Probable value
Ecommerce item
=
IS_ECOMM_ITEM
Y or N
Image file
=
ECOMM_IMG_FILE
xyz.jpg
Charge tax-1
=
ECOMM_TXBL_1
Y or N
Charge tax-2
=
ECOMM_TXBL_2
Y or N
Charge tax-3
=
ECOMM_TXBL_3
Y or N
New
=
ECOMM_NEW
Y or N
Until
=
ECOMM_NEW_UNTIL
Date (required for NRO, if item is to be flagged as new)
Add Comment
Subscribe to Article
Print Article
Email Article to Friend
Export to MS Word