How do you set up Combined Shipping in Magento 1.9?

[falken76]

I would like to set up combined shipping in Magento 1.9 but I can't figure it out.  I want a fixed rate of $2.99 for the initial product and then .25 cents for each additional.  I would like that to be a rule set for domestic orders and I would also like to set international rates to $8.99 fixed rate for teh initial purchase, then $.99 for each additional.  Is this possible?  I can't really find anything like I'm trying to do on google.  This is pretty standard on venues like ebay and the like. 

[KentChr_DK]

Hi @falken76,

I think you should use the tablerates shipping rate, and then choose rate-setting based on qty ?

Then setup the rates in a .csv file for Magento to use when calculating the shipping costs.

Please have a look at this for reference and ideas to your setup:

http://webshopapps.com/eu/premium-matrixrate-shipping-extension.html

Please let me know if this helps

[falken76]

Thank you so much.  I just saw a video on youtube explaining table rates.  I'm very confused.  I am selling on sites like ebay and etsy where you just put the numbers in a field.  Doing this myself is overwhelming.  I exported the CSV for table rates, but I have no idea what I'm doing.

I want to set shipping for domestic and for international.

I want the flat rate of $2.99 for the first shipment and $.25 for each additional for domestic

I want a flat rate of $6.99 for the first shipment and $.99 for each additional for international.

I don't understand how to convey this in the spreadsheet.  Here are the tabs:

Country: The video shows him entering USA, but other references say there's a number system to identify countries, and do I have to have entries for every single country if I'm selling world wide?  Is there not a wildcard I could use to apply the same rule to all countries but the US?

Region: I planned on using the * wildcard here

Zip/postal: same wildcard

# of Items (and above): This one confuses me, would this be 0-1 if I want the first item to be set to $2.99?  I want anything above 1 to charge .25 cents.

Shipping price: I know to put $2.99 here, but I'm confused about where to put the additional .25 cents.  Would that be on the next line?  For instance, I would have to set country, region and zip again, then for # of items, would I put 2-* ? and THEN put .25 in the second shipping field?

Finally

If the above is correct, does that mean I have to have two entries for every single country?

I must be wrong, there has to be an easier way.  Thank you very much for the help, I'm just not even close to you guys ability wise, I know nothing about code, I rarely use spreadsheets and I have only set my things up on venues via GUIs that are probably idiot proofed.   Thank you for being so patient with me, I feel like a fool trying to figure this all out.

[KentChr_DK]

Hi @falken76,

Yes - there will be 2 lines  (one for the original price + one for add. products).

Please check this link:

https://elgentos.nl/tablerates/

Input your default price

There you will be able to choose "#items vs. destination" in the dropdown: Table rates condition

Insert rest and press "Generate csv tables".

Let me know if this helps

[falken76]

Thank you.  I found that utility on google, but it was in pounds not US dollars, does that matter?  Can I just change the field on the CSV once it is generated and it will still work when currency is set to USD?

[KentChr_DK]

Try simple "Search and replace" when the .csv file is done and downloaded on your pc.

The replace € with USD and save it.

Remember to use OpenOffice calc or similar when working with .csv files.. Microsoft products sucks.

And check saving format is UTF-8

Then try to upload the edited .csv file to Magento, empty all caches, and test your frontend