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.
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:
Please let me know if this helps
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?
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.
Yes - there will be 2 lines (one for the original price + one for add. products).
Please check this link:
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
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?
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