Looking for some help please…
* I have multiple websites (4 in total) with a single store view each.
* Each store_view has its own root catalog.
* Every product is a simple product but some of them have tier pricing.
I am using Magmi on the cli with 5 different CSV files (admin, storeA, storeB, storeC, storeD), imported in that order. (admin and storeA will share the same values)
My problem is that Magmi is importing almost everything correctly but messing up my pricing between the sites.
Basically the price for the last store imported (storeD) is being set as the default value (admin) for all sites. Also, tier_pricing is showing on all sites apart from storeA.
In the CSV files, i have the following columns (some non-important ones removed for clarity):
sku, store_id, store, websites, type, category_ids, price, tier_price:siteA, tier_price:siteB, tier_price:siteC, tier_price:siteD,....
I have checked the store_id’s for each CSV (admin = 0, storeA = 1, storeA = 2, storeA = 4, storeA = 5… yes 3 is supposed to be missed) and they are all correct.
I have checked the store titles for each CSV and they all specify a valid and correct store_view name.
Websites column lists all websites in admin csv, and only specifies the current website when specified in storeA-D CSVs.
Tier pricing is actually getting imported OK, it’s just not showing up for storeA… although I can clearly see it is assigned to the product when in the administration area.
I have Googled and read forums for days now and I cannot find any information regarding multiple-website pricing imports and I am pulling my hair out here so any help would be hugely appreciated.
Thanks in advance!
It turns out that the Tier prices that were not showing in storeA is because the tier prices only show when user is logged in. (storeA is our retail outlet so all products are visible whereas B,C and D are closed to public).
Magmi imports the Tier prices like:
All websites, Customer Group, Qty, Price
I need to import the tier prices like:
Specific Website, ALL GROUPS, Qty, Price
Also, If I use the same CSVs in dataflow after the Magmi import, the prices are all correct per store but this defeats the point of using Magmi in the first place as the dataflow import is sooo sloooow.