Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
Magmi - Targeting specific site and stores
HGP-IT
UK

Not so New
June 8, 2016 - 2:09 pm
Member Since: February 21, 2016
Forum Posts: 5
sp_UserOfflineSmall Offline

I am having trouble importing products into Magento EE v1.14.x via Magmi v0.7.23 where I need to retain association of products against existing Magento websites.

My CSV file is generated from our master products database system. I can completely change the format with which the CSV is output as it’s a script I am developing in-house.

Say I have 5 websites + admin:

admin
www_site1_com
www_site2_com
www_site3_com
www_site4_com
www_site5_com

www_site1_com and www_site3_com already have product SKU ‘123456’ assigned.

I want to import SKU ‘123456’ via Magmi, so it’s assigned to www_site5_com AS WELL AS any existing sites.

Ideally, I would want to configure the CSV as:

websites,sku,visibility
“*,www_site5_com”,123456,4

Alas, I have tried this, but it doesn’t appear to accept ‘*’.

My data set will eventually have 1m+ products with a dozen or more websites, so I really need to be able to do this in an automated, scalable way, i.e.: manually editing the CSVs to edit the websites columns based on target sites is never going to be an option.

Does anyone know a way to do this via Magmi? Else I will have to look at querying Magento for every SKU, during my CSV creation process, and building an array of all currently assigned websites, to populate my ‘websites’ column’, which just seems sloppy – if it’s even possible.

P.S. I can’t just specify a store instead, as Magmi/Magento decides to assign the SKU to every website when I do this.

Thank you!

Paul Cartwright
West Midlands, UK

Partner
June 8, 2016 - 3:23 pm
Member Since: January 7, 2015
Forum Posts: 414
sp_UserOfflineSmall Offline

the website column in magmi is no longer, you use the store heading which is where you put store view code in.

As the websites will be set up in magento separately with own root category meaning each website will have own store view and therefore the product will only be added to that store view.

To assigned products to different root categories [root category]/category/category and separate by ; or maybe ;; can’t remember of the top of my head if you need to assign products to more than one category

That’s using magento ce not ee

Hope that helps
Paul

Everyday is an opportunity to learn something new

HGP-IT
UK

Not so New
June 8, 2016 - 3:45 pm
Member Since: February 21, 2016
Forum Posts: 5
sp_UserOfflineSmall Offline

Hi Paul,

Thank you for your reply.

The websites column does work as we have tested it extensively and observed definite effects of using it. Dweeves also confirms that it was re-instated a while back here: https://github.com/dweeves/magmi-git/issues/23.

I can’t help thinking this is actually some kind of bug we’ve found, as we have noticed a number of people with similar problems/expectations regarding the ‘websites’ column. For instance:
https://github.com/dweeves/magmi-git/issues/445
https://understandinge.com/forum/magmi-forum/product-update-import-issue-assigning-product-to-second-website-multi-store/

As one poster noticed, if you specify a target website in your CSV and the SKU already exists in another website (e.g.: ‘site1’) then Magmi actually ‘moves’ the SKU to the targeted website from its existing website, i.e.:

websites,store,sku,…
site2,store2,123456,…

We’d expect Magmi to just apply the updates to the SKU under that specific website/store, not actually move it!

Thanks

Paul Cartwright
West Midlands, UK

Partner
June 8, 2016 - 4:05 pm
Member Since: January 7, 2015
Forum Posts: 414
sp_UserOfflineSmall Offline

I run a multi site set up, I use the store column only and manage to get products on more than one website by using the store code.

e.g store
store1,store2

Everyday is an opportunity to learn something new

 

Why Should You Join UnderstandingE?

 
  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks

 

Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
14 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5223

Posts: 27502

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606