Hi,
I am looking at moving to CS Cart and all looks good but I am not sure I can do shipping by Postcode.
In Australia the postage costs vary widely and I need to provide for each postcode or a range a fixed amount plus an amount per kg. This is how my courier Stratrack Express charges.
The Australia Post Shipping module looks good but I need a module for my courier too.
I have an excel spreadsheet which maps postcode to a courier cost code (ie a fixed rate plus rate per kg) but the list is 25,000 lines long - thats how many postcodes there are. I could group them in some way as there are less courier cost codes but need to be able to assign to groups of postcodes.
Does anybody know if this is possible in some way with CS Cart ?
Thanks
Paul
Hello, Paul!
Yes, it is possible in CS-Cart. The shipping rates are set for locations and location can be set as a group of postcodes. But, I am afraid, you will need to configure this manually.
Here you can find some instructions:
CS-Cart Documentation — CS-Cart 4.15.x documentation
CS-Cart Documentation — CS-Cart 4.15.x documentation
Hi Kate,
Thankyou.
I see you can use wild cards like * and ? for postcodes.
Can I also use ranges like 1000-2000 meaning all postcodes between these two numbers.
Paul
I just tried with two different postcodes on different lines and the postage calculated OK for both of these postcodes.
Would be good to be able to do a range of postcodes like 2000 to 2100 for example. Otherwise I will have to enter all 25,000 postcodes !!!
PB
Yeah, The Post Code logic leaves a lot to be desired.
For example to do range 2000 to 2100
20??
2100
Range for 1000-2000
1???
2000
Understand?
I can what you are suggesting but the actual ranges I need are more complicated.
For example 2130-2250 might be one range and one location but 2251-2300 may be another location. The wildcards will not work here.
Paul
Yeah that's why I said cs-cart ranges are a pain the the butt.
2130-2250
213?
214?
215?
216?
217?
218?
219?
220?
221?
222?
223?
224?
2250
I'm still on version 1.3.5 so I'm not sure if this will work for your version but to put in my postcodes, I had them all in an Excel spreadsheet sorted into the different destinations which was supplied by my courier. I just copied them from Excel into my cart.
If you want to use the Australia Post delivery zones, this is available in .csv format on their website.
It may not be possible to do this in later versions but I just thought I would mention it.
I used this solution and it works well. There are only a couple of thousand postcodes I found out, the file I had was for every locality and many localities of the 25,000 have the same postcode.
Thanks
I should have mentioned I filtered the lists through Excel first, which got rid of the duplicates. Glad it worked for you.
Yes this is a big problem when setting up shipping locations for Australia.
The job would be much easier if a numerical range could be defined,
For Australia Post there are about 28 zones, most of which are ridiculously complicated to define using cscart locations, even with the wildcard format.
For example.
Australia Post zone: VIC COUNTRY [V2] takes forever to define.
2648, 2715, 2717-2719, 2731-2739, 3221-3334, 3342-3349, 3351-3352, 3357-3424, 3444-3749, 3812-3909, 3921-3925, 3945-3971, 3979, 3984-3999
Which would be entered as:
2648
2715
2717
2718
2719
2731
2732
2733
2734
2735
2736
2737
2738
2739
3221
3222
3223
3224
3225
3226
3227
3228
3229
323?
324?
325?
326?
327?
328?
329?
330?
331?
332?
3330
3331
3332
3333
3334
3342
3343
3344
3345
3346
3347
3348
3349
3351
3352
3357
3358
3359
336?
337?
338?
339?
340?
341?
3420
3421
3422
3423
3424
3444
3445
3446
3447
3448
3449
345?
346?
347?
348?
349?
35??
36??
370?
371?
372?
373?
374?
3812
3813
3814
3815
3816
3817
3818
3819
382?
383?
384?
385?
386?
387?
388?
389?
390?
3921
3922
3923
3924
3925
3945
3946
3947
3948
3949
395?
396?
3970
3971
3979
3984
3985
3986
3987
3988
3989
399?
(unless Ive made a mistake)
Come to think of it… perhaps, for the benefit of other Ozzy CScart users … is someone willing to post/upload the text lists for each of the Australia Post zones (eg N1, GF, WG … AAT)?
Also, can the postcodes be comma separated rather than one per line?
ie: This:
[quote]2648,2715,2717,2718,2719 [/quote]
instead of this:
[quote]2648
2715
2717
2718
2719[/quote]
[quote name='remoteone' timestamp='1354421516' post='150236']
Come to think of it… perhaps, for the benefit of other Ozzy CScart users … is someone willing to post/upload the text lists for each of the Australia Post zones (eg N1, GF, WG … AAT)?
[/quote]
Go to the Australia Post “Find a Postcode” page. There is a link that says “Our postcode data is available to download for non-commercial use”. Click and fill in the form to receive the email with the link to download the data. This will give you an Excel file. Sort the Excel file by Parcel Zone. Delete all columns except the Parcel Zone column and the Postcode column. Filter the list to remove duplicate postcodes. You can then copy and paste the relevant postcodes when setting up the locations. No need for wildcards or ranges. Every single postcode is included separately and there are 16 zones.
If setting up your own postage for a freight company, they also have similar zones and most can provide a list similar to the Australia Post list.
Thanks Lyn, very useful instruction.
Actually, for our eParcel account, shipping from SA, there are 28 zones.
if you include Norfolk Island, Antarctic Territories and some of the simplified 16 zones are broken up into minor zones making 28.
I might make these available in .txt files when finished.
Attached Zip contains .txt files listing Postcode definitions using CScart wildcards
28 zones
Please let me know if there any errors found, no warranty …
Thanks remoteone…very useful info. Would really apreciate if anyone can help.
I have a shipping problem -
There are some products on my store which can be sent to all over Australia and some products which can be sent to all over Australia except two states (WA and TAS).
If someone from WA or TAS selects a product that cannot be sent to him, the shipping calculator still calculates the postage and then they go ahead and checkout.
How can I control shipping based on specific states?
I spent entire day playing with localizations and locations but I realised that you can only set locations based on countries and not states. So shipping calculator calculates the cost based on selection of country rather than based on states. And that’s why it gives the shipping cost for WA because the country selected is still Australia.
I am using ‘Australia Post real-time calculatorâ€
Cheers,
Anil
www.plantbiotech.com.au/store
Hi Anil , you can set states in locations, but I can see a problem that you cant set some products to not ship to certain locations.
What is the the limitation/restriction of posting the particular product?. If its a weight restriction then I think you can do it by setting up a different shipping method. But if its a “prohibited item” then I do see the problem.
Thats somethingg that should be made available in shipping methods … a suggestion for cscart.uservoice.
Products can have “Product features”. so if a Location" or a Shipping method could be made specific to a Product Feature that may solve the issue.
Maybe this addon will help you. It allows certain products to have only one shipping method.
[url=“ADDON: Supported Shipping Methods - Third-Party Add-ons - CS-Cart Community Forums”]ADDON: Supported Shipping Methods - Third-Party Add-ons - CS-Cart Community Forums
[quote name='remoteone' timestamp='1355650158' post='151252']
What is the the limitation/restriction of posting the particular product?. If its a weight restriction then I think you can do it by setting up a different shipping method. But if its a “prohibited item” then I do see the problem.
Thats somethingg that should be made available in shipping methods …
http://forum.cs-cart…__fromsearch__1
[/quote]
Exactly…and everywhere I read that shipping settings are based on locations. I think they are based on localizations! I may be wrong. There is no 'Location' selection in shipping method. I could see 'Localization' selection only.
But you are spot on. Yes the products are certain plants that are prohibited in WA and TAS.
I set the following localization on my store:[list=1]
[]Overseas customers
[]Australian customers
[*]WA/TAS customers
[/list]
If a customer from WA/TAS sets the correct localization then the prohibited products are not displayed and so they cannot added to the cart. Problem solved.
This holds true only if the WA/TAS customers sets the correct localization. But what is the probability that any customer will check the localization first? It is too much to expect that every customer visiting your store would check and change the localization to their location.
What is required here is an automatic setting of mapping IP to country and then if its Australia then automatic mapping it further to states. But I guess that’s highly impossible.
Right now If a customer from WA/TAS visit the store, the localization is set at default as ‘Australian customers’ and that’s why the store treats them as Australian customers and let them add the products which are not available to them. And then it calculates shipping as well.
Should the store recognize them as WA/TAS customer and change the localization automatically to WA/TAS then it would solve the problem. But I know that isn’t going to happen.
I guess the addon you suggested works like below:
If you chose certain product > it will show specific shipping method
What I want is,
If you chose certain products and certain state > it should show available shipping method or show error msg.
This works for me, if overseas customer lands in the store and the localization is still Australian Customers. If they buy products that cannot be shipped to them then it shows error msg.to overseas customers but it doesn’t work for States within Country.
how to modify the warning message if the postcode entered is not shipped to that postcode
hi guys please help. i managed to fix the shipping cost 7.50 but somehow when i entered postcode 3000, the cost of shipping shown $100. I have never set this one up, how it came out with $100 . please please desperate here
(solved. Helpdesk could not what it was but delete the the shipping method and recreate one solve the issue, this juz cost me 10 credits)