Kryptronic Software Support Forum

cybermed · 10-14-2003 20:11:33

Nick, How can I globally modify ALL products from the default Shipping " Product Based Shipping" to "Custom Shipping? Evan

EagleWolf · 10-14-2003 20:17:40

Easiest way would be to download the product.csv file and modify the shipping type table. save and upload in binary to the data/tables folder.

If you are using mysql covert back to csv before downloading and making your change.

webmaster · 10-15-2003 08:30:58

Even easier: Under Database Utilities | SQL Statement Submission, execute an UPDATE command on the product table like this:

Code:


UPDATE product SET
product_delmethod='C',
product_customship='ste_shipcus_user'
WHERE product_delmethod='P'

The 'product_customship' portion of the statement sets the script to the user defined calc. Use a different script there if you have a different one set up. To do this update to all products regardless of whether they're set to product based right now, remove the WHERE portion of the statement.

cybermed · 10-20-2003 11:28:08

I did the update above and some items updated the Shipping to Custom and others did not. Any suggestions?

GREAT SUPPORT NICK:)

webmaster · 10-20-2003 11:59:17

Perhaps those items were not using the product based shipping method. To do ALL products, use this SQL (has no WHERE statement in it):

Code:


UPDATE product SET
product_delmethod='C',
product_customship='ste_shipcus_user'

Kryptronic Software Support Forum

#1 10-14-2003 20:11:33

Globally Modify Shipping

#2 10-14-2003 20:17:40

Re: Globally Modify Shipping

#3 10-15-2003 08:30:58

Re: Globally Modify Shipping

Code:

#4 10-20-2003 11:28:08

Re: Globally Modify Shipping

#5 10-20-2003 11:59:17

Re: Globally Modify Shipping

Code:

Board footer