Just quickly checking in before I go out for the day.
Use the “Special” columns in the csv. Look for Special From, Special To and Special Price. I can’t remember the exact attributes from the top of my head.
I think that when you add a category in a Product Import CSV it creates a Category (just with the basic information though). I haven’t tested this properly, but it was something I noticed once.
Delivery Charges will depend on what Module you use to control this. If you’re referring to the Table Rates, then yes. You need to go to Stores > Configuration > Sales > Shipping Methods > Table Rates. The trick is at this point it to change your Store View (upper-left) from Default Config to Main Website. This will then display an Import button for the site. I stumbled across this website once, which may or may not help you to format a csv.
I’ve never imported an image from an external source, but in theory it should work fine so long as it can access it.
Thanks for your reply I figure it out with uploading images.
but now I am stuck with delivery chargers. I do have different prices for different products and different price for different states and also I do free delivery on most of the items.
How do we make this happen?
Hi,
Hmmm. As Craig mentioned in his message it depands what shipping module/method you use.
Please let me know what shipping method you use so I can do a small research
Personally, I use £159 shipping table rates module from Amnasty.
There are many modules like this available online. I can manage my shipping based on country, state, value of the order, weight, quantity, product type.
Thanks for your reply. In above CSV we can use country and State, how do I add SKU.
For an example SKU:XYZ to Australia Victoria state will cost $100 .
With this module, you don’t have to associate SKU with a courtier.
You see it depends on what criteria you are going to use to calculate your shipping cost.
If price all your products have prices, if the weight you need to make sure that your products have the correct weight, if shipping type you need to create a shipping type attribute and here you need to associate it with SKU via csv update or update attributes options (Catalog/products/Actions)
This is how my cost looks like in my CSV file. I can not understand how do I do that with this small details as it does not include weight and price is not an option.
12 is the only product charge for delivery and other things are coming with free delivery.