INVENTORY:Re: remotely creating and populating a stock inventory db - almost there!
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24592
interpreted = N
texte = LOUISE You may want to keep an eye on this thread it is dicussing the ways to do the inventory..John Butler wrote:> Good day :-)>> ***** I need help from you serious webcat programmers out there.. ******>> This is a bit long but some may find some useful code they want :-)>> My site sells items that come in different sizes and colors and I want to offer all> those different sizes and colors using only one SKU per item. I am nearly successful>> in creating an additional feature of my site's admin area which will allow the admin> person to create (via browser) and view a db (which is relational to the main> products.db)> that stores a SKU's number in stock (NIS) for each size/color variation of that> SKU. (Note that there is no limit to the number of fields one can create as with the> recent omnibase app.)>> I just need help with that last section below (FGA-ProductNIS-3.tmpl), but I'll> post the code for the preceding pages as well so you see where I am going and so people> can> have the code if they want. These pages work great to create the db properly, and in>> populating it (the [replace] in FGA-ProductNIS-3.tmpl), but in viewing the> final db (the
in FGA-ProductNIS-3.tmpl), the rows of values shown in the> table do not match with the records in the db. Sooo close... I just need this last> 'viewing of> the db' working because I want the user to be able to resubmit to repopulate all the> fields in all the> records if needed.>> Any help would be GREATLY appreciated.>> try it out!!>> (In all pages, only the relevant code is included.)>> -----------------------[FGA-ProductCatalog.tmpl]----------------------->> > > > > > >> [Search db=FG-products.db&neSKUdata=NadaAmingo&max=100]> [foundItems]> setup> [/foundItems]> [/Search]> > >> -----------------------[/FGA-ProductCatalog.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-0.tmpl]----------------------->> > > > > > > Choose how many fields and records for NumInStock database for Product#> [SKU]
>> > > >> -----------------------[/FGA-ProductNIS-0.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-1.tmpl]----------------------->> > > > > > > Choose size options and color options for the upcoming NIS-[SKU].db for> Product# [SKU]
>> > > >> -----------------------[/FGA-ProductNIS-1.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-2.tmpl]----------------------->> > > > > > >> [WriteFile NIS-[SKU].db]NumSizes NumColors color[loop start=1&end=[NumSizeOpts]&advance=1]> [interpret][NISSize[index]][/interpret][/loop]> [/WriteFile]> [loop start=1&end=[interpret][NumColorOpts][/interpret]&advance=1][Append> db=NIS-[SKU].db]NumSizes=[NumSizeOpts]&NumColors=[NumColorOpts]&color=[interpret][NISColor[index]][/interpret][/Append][/loop]>> [interpret][closedatabase NIS-[SKU].db][/interpret]>> Please enter values for NIS (Number In Stock) for each size/color variation> for db- NIS-[SKU].db
>> > > >> -----------------------[/FGA-ProductNIS-2.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-3.tmpl]----------------------->> > > > > > > [Search db=NIS-[SKU].db&necolordatarq=nadaamigo][FoundItems][text> show=f]Findex=[index][/text]> [Replace db=NIS-[SKU].db&eqcolordatarq=[color]]color=[color][loop> start=1&end=[NumSizeOpts]&advance=1][text> show=f]Lindex=[index][/text]&[interpret][NISSize[Lindex]][/interpret]=[interpret][x[Lindex]y[Findex]][/interpret][/loop][/Replace]>> [/FoundItems][/Search]> [interpret][COMMITDATABASE NIS-[SKU].db][/interpret]>> See your newly populated COLOR=#AA1177>NIS-[SKU].db
>> > > >> -----------------------[/FGA-ProductNIS-3.tmpl]----------------------->> *****************************************************************************>> -------------------------------------------------------------> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.> To end your Mail problems go to .>> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to -- _/_/_/CyberLive, Inc.\_\_\_ _/_/_/_/_/ Jym Duane \_\_\_\_\_\_ Marketing / Custom Design \ E-Commerce Phone: (949) 443-1323 Fax: (949)443-1360 Email: sales@cyberlive.com Web: http://www.cyberlive.com _/_/_/_/_/_/_/_/_/_/_/_/_/_/ \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\__/_/_/_/_/_/_/ The Internet Services Professionals \_\_\_\_\_\_\_31781 Camino Capistrano, Suite 302, San Juan Capistrano, CA 92675-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
LOUISE You may want to keep an eye on this thread it is dicussing the ways to do the inventory..John Butler wrote:> Good day :-)>> ***** I need help from you serious webcat programmers out there.. ******>> This is a bit long but some may find some useful code they want :-)>> My site sells items that come in different sizes and colors and I want to offer all> those different sizes and colors using only one SKU per item. I am nearly successful>> in creating an additional feature of my site's admin area which will allow the admin> person to create (via browser) and view a db (which is relational to the main> products.db)> that stores a SKU's number in stock (NIS) for each size/color variation of that> SKU. (Note that there is no limit to the number of fields one can create as with the> recent omnibase app.)>> I just need help with that last section below (FGA-ProductNIS-3.tmpl), but I'll> post the code for the preceding pages as well so you see where I am going and so people> can> have the code if they want. These pages work great to create the db properly, and in>> populating it (the [replace] in FGA-ProductNIS-3.tmpl), but in viewing the> final db (the in FGA-ProductNIS-3.tmpl), the rows of values shown in the> table do not match with the records in the db. Sooo close... I just need this last> 'viewing of> the db' working because I want the user to be able to resubmit to repopulate all the> fields in all the> records if needed.>> Any help would be GREATLY appreciated.>> try it out!!>> (In all pages, only the relevant code is included.)>> -----------------------[FGA-ProductCatalog.tmpl]----------------------->> > > > > > >> [Search db=FG-products.db&neSKUdata=NadaAmingo&max=100]> [founditems]> setup> [/foundItems]> [/Search]> > >> -----------------------[/FGA-ProductCatalog.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-0.tmpl]----------------------->> > > > > > > Choose how many fields and records for NumInStock database for Product#> [SKU]
>> > > >> -----------------------[/FGA-ProductNIS-0.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-1.tmpl]----------------------->> > > > > > > Choose size options and color options for the upcoming NIS-[SKU].db for> Product# [SKU]
>> > > >> -----------------------[/FGA-ProductNIS-1.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-2.tmpl]----------------------->> > > > > > >> [WriteFile NIS-[SKU].db]NumSizes NumColors color[loop start=1&end=[NumSizeOpts]&advance=1]> [interpret][NISSize[index]][/interpret][/loop]> [/WriteFile]> [loop start=1&end=[interpret][NumColorOpts][/interpret]&advance=1][Append> db=NIS-[SKU].db]NumSizes=[NumSizeOpts]&NumColors=[NumColorOpts]&color=[interpret][NISColor[index]][/interpret][/Append][/loop]>> [interpret][closedatabase NIS-[SKU].db][/interpret]>> Please enter values for NIS (Number In Stock) for each size/color variation> for db- NIS-[SKU].db
>> > > >> -----------------------[/FGA-ProductNIS-2.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-3.tmpl]----------------------->> > > > > > > [Search db=NIS-[SKU].db&necolordatarq=nadaamigo][founditems][text> show=f]Findex=[index][/text]> [Replace db=NIS-[SKU].db&eqcolordatarq=[color]]color=[color][loop> start=1&end=[NumSizeOpts]&advance=1][text> show=f]Lindex=[index][/text]&[interpret][NISSize[Lindex]][/interpret]=[interpret][x[Lindex]y[Findex]][/interpret][/loop][/Replace]>> [/FoundItems][/Search]> [interpret][COMMITDATABASE NIS-[SKU].db][/interpret]>> See your newly populated COLOR=#AA1177>NIS-[SKU].db
>> > > >> -----------------------[/FGA-ProductNIS-3.tmpl]----------------------->> *****************************************************************************>> -------------------------------------------------------------> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.> To end your Mail problems go to .>> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to -- _/_/_/CyberLive, Inc.\_\_\_ _/_/_/_/_/ Jym Duane \_\_\_\_\_\_ Marketing / Custom Design \ E-Commerce Phone: (949) 443-1323 Fax: (949)443-1360 Email: sales@cyberlive.com Web: http://www.cyberlive.com _/_/_/_/_/_/_/_/_/_/_/_/_/_/ \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\__/_/_/_/_/_/_/ The Internet Services Professionals \_\_\_\_\_\_\_31781 Camino Capistrano, Suite 302, San Juan Capistrano, CA 92675-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Jym Duane
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:
Multiple SSL Keys (1998)
Lost Field (1998)
5.0 Preview Promotion Extension (2003)
Attn: Mike Davis (2000)
possible, WebCat2.0 and checkboxes-restated (1997)
PIXO support (1997)
Shopping Cart - prices? (1997)
Why is deleting so slow? (2002)
japanese characters (1997)
verify online (1997)
Simple way to create unique SKU (1997)
UPS charges (2000)
NT error logs (1997)
Are you an WC expert? (1997)
RE: type 2 errors with ssl server (1997)
Why isn't this working (1999)
A quickie question (1997)
Tool of Use to Unix WebCat Admins (2000)
Generating unique SKU from [cart] - Still Stumped... (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)