Re: Country & Ship-to address & other fields ?
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10296
interpreted = N
texte = >Since we ship internationally and we also allow a ship-to addresses which >may be different from the billing addresses: Where is the logical place >to store this information within the current database structure >(WebCatalog & WebMerchant) ?The logical place is in header1-5, but as you can see there are only 5 of those (restricted to 99 characters each). It is a priority (after WebCatalog 2.0 release) to increase the number of fields for the WebMerchant shopping cart format.>It isn't yet clear to us if we are restricted to using the fields listed >as required or reserved or if we can come up with our own fields which >are accessible from .tmpl to .tmpl and can also be passed on to >WebMerchant ? Any time you are putting stuff into a shopping cart (or sending to WebMerchant) you are limited to the fields we define in the cart.>If we can define our own, where do we define them and/or store them ? Is >there a separate database or text file where the standard and new fields >are defined and stored ?If you are using Commerce Lite, then I recommend you do not store them in the cart (you can't, so why try), but rather you should ask for that information on the last purchase page and simply include those fields in the outgoing email that gets sent to your fulfillment house. The data will not be stored in the cart, but at least you'll have it in the email. Alternately you may wish to create a parallel relational database that contains all the extra information you want. The cart number is the natural id for linking order files to database records that contain extra info.Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>Since we ship internationally and we also allow a ship-to addresses which >may be different from the billing addresses: Where is the logical place >to store this information within the current database structure >(WebCatalog & WebMerchant) ?The logical place is in header1-5, but as you can see there are only 5 of those (restricted to 99 characters each). It is a priority (after WebCatalog 2.0 release) to increase the number of fields for the WebMerchant shopping cart format.>It isn't yet clear to us if we are restricted to using the fields listed >as required or reserved or if we can come up with our own fields which >are accessible from .tmpl to .tmpl and can also be passed on to >WebMerchant ? Any time you are putting stuff into a shopping cart (or sending to WebMerchant) you are limited to the fields we define in the cart.>If we can define our own, where do we define them and/or store them ? Is >there a separate database or text file where the standard and new fields >are defined and stored ?If you are using Commerce Lite, then I recommend you do not store them in the cart (you can't, so why try), but rather you should ask for that information on the last purchase page and simply include those fields in the outgoing email that gets sent to your fulfillment house. The data will not be stored in the cart, but at least you'll have it in the email. Alternately you may wish to create a parallel relational database that contains all the extra information you want. The cart number is the natural id for linking
order files to database records that contain extra info.Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[WebDNA] Conditional search (2009)
emailer truncates last letter! (1997)
Re:2nd WebCatalog2 Feature Request (1996)
re: Large databases in WebCat (1997)
F3 crashing server (1997)
Exclude by date - multiple (1997)
Extended [ConvertChars] (1997)
WebCatalog 2.1b3 - Plugin or cgi ? (1997)
Email notification to one of multiple vendors ? (1997)
Extended [Convertchars] needed (1997)
looping through the headers of an orderfile (2000)
Counting records (2000)
Beta 18 (1997)
Corrupted filetypes with [movefile] (1998)
Purchae error - Fixed to a degree (1997)
OFF-TOPIC: Check www.godaddy.com for me ... (2003)
[WriteFile] problems (1997)
[WebDNA] SOAP support (2014)
WC2b15 File Corruption (1997)
Firesite and [referrer] atg broke (1997)