Zen Cart Logo
Forums / Addon Shipping Modules / Canada Post package info change all

Canada Post package info change all

Views: 1,400

Results 1 to 7 of 7
15 Jun 2014, 1:22 PM
#1
lukaswlu avatar

lukaswlu

New Zenner

Join Date:
Mar 2014
Location:
Canada
Posts:
31
Plugin Contributions:
0

Canada Post package info change all

So all my items have teh same length/width/weight entered. and Read to ship info. I would like to change those settings. I have 4000 items so need to change it all at the same time. I think i set this up somewhere but can't find the option anymore. I want to have most of my itemes weight of 0.1 and item not ships in original box. and then the bigger items I will change manually as there isn't too many.

Attachment 14174

canda post.jpg
18 Jun 2014, 1:00 AM
#2
lukaswlu avatar

lukaswlu

New Zenner

Join Date:
Mar 2014
Location:
Canada
Posts:
31
Plugin Contributions:
0

Re: Canada Post package info change all

anyone has suggestions? :(

18 Jun 2014, 1:43 AM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Canada Post package info change all

You can write your own SQL queries to manage your settings for the relevant fields in the products table:
products_weight_type
products_dim_type
products_length
products_width
products_height
products_ready_to_ship

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

18 Jun 2014, 2:13 PM
#4
lukaswlu avatar

lukaswlu

New Zenner

Join Date:
Mar 2014
Location:
Canada
Posts:
31
Plugin Contributions:
0

Re: Canada Post package info change all

will this get loaded up by easypopulate?

18 Jun 2014, 6:11 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Canada Post package info change all

lukaswlu:

will this get loaded up by easypopulate?
I dunno. I don't use easypopulate.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

19 Jun 2014, 2:42 PM
#6
lukaswlu avatar

lukaswlu

New Zenner

Join Date:
Mar 2014
Location:
Canada
Posts:
31
Plugin Contributions:
0

Re: Canada Post package info change all

is there a sql command to change all my items to be not ready to ship. I tried adding the columns in the cvs v_products_ready_to_ship to easy populate and it did not work.

21 Jun 2014, 12:42 AM
#7
lukaswlu avatar

lukaswlu

New Zenner

Join Date:
Mar 2014
Location:
Canada
Posts:
31
Plugin Contributions:
0

Re: Canada Post package info change all

send you pm