Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
Product UPDATE Import - Issue assigning product to second website / multi store.
group-am

Excellent
May 25, 2016 - 10:50 pm
Member Since: January 27, 2015
Forum Posts: 14
sp_UserOfflineSmall Offline

We have two websites. Each website has its own store view. We have tried a dozen plus combination of upload sheets, and have been successful ZERO times. Right now, all products are assigned to the default / main website. We want to also associate certain SKUS with the second / spin off website. That would then make them belong (display) to both sites / stores.

When we add a NEW product, and put store ‘Admin’, it assigns SKUS to both the Main Website, and the Spin Off site… great.

When we add a NEW product, and put store ‘default’, it assigns SKUS to the main website… great.

We want to UPDATE existing specific SKUS, and associate them with the new website.

My Manage Stores area looks like this (following the exact order / format of the Magento Backend):

Website Name
store2.com
(Code: store2)
Main Website
(Code: base)

Store Name
store2.com
(Root Category: store2.com)
Main Website Store
(Root Category: Default Category)

Store View Name
store.com
(Code: store2)
Default Store View
(Code: default)

All my research, says this SHOULD work (first row column headings):

sku,store
item1,”default,store2″

Any help appreciated!!!
-Group-AM

Paul Cartwright
West Midlands, UK

Partner
May 26, 2016 - 12:07 pm
Member Since: January 7, 2015
Forum Posts: 414
sp_UserOfflineSmall Offline

To run multiple websites through 1 magento install.

Each website needs to be set up as a individual website (website name, store name, store view)
Each needs website needs to have a root category.
Then when importing using magmi in the store column put the store view you want to put the product on to and hey presto

I assume to you have put them as add on domains, pointed the add on domains to your server and added the necessary code to the htaccess file

Hope this helps
Paul

Everyday is an opportunity to learn something new

group-am

Excellent
May 26, 2016 - 4:50 pm
Member Since: January 27, 2015
Forum Posts: 14
sp_UserOfflineSmall Offline

Paul Cartwright said
To run multiple websites through 1 magento install.

Each website needs to be set up as a individual website (website name, store name, store view)
Each needs website needs to have a root category.
Then when importing using magmi in the store column put the store view you want to put the product on to and hey presto

I assume to you have put them as add on domains, pointed the add on domains to your server and added the necessary code to the htaccess file

Hope this helps
Paul  

Thanks Paul for the reply. We already have both sites up and running off one Magento Installation no problem.

Both sites / domains are operational, point properly, have unique CMS pages, etc. assigned to the different sites.

We are missing the “Hey Presto” part.

Again, we have used the Store column with the Store View we want to add the product to, and it flat out does not work.

Paul Cartwright
West Midlands, UK

Partner
May 26, 2016 - 4:56 pm
Member Since: January 7, 2015
Forum Posts: 414
sp_UserOfflineSmall Offline

I think its because you have set them up under one website with different store views when separate websites should be set up under different website names therefore store name/store view and allocated a root category per website.

That’s how I set mine up and it works a treat.

Everyday is an opportunity to learn something new

group-am

Excellent
May 26, 2016 - 7:25 pm
Member Since: January 27, 2015
Forum Posts: 14
sp_UserOfflineSmall Offline

Perhaps I am not understanding what you are saying, or you are not understanding what I am saying…

The whole platform / architecture works… perfectly. It has already been tested, and is functional. I can manually assign products to one website, or both. So I know everything is configured and 100% working.

When a product is manually assigned to a website(s), when under the “Catalog > Manage Product” on the backend of Magento, under the ‘Websites’ column, you see both listed (i.e. “Main Website,store2.com). If only assigned to the main website when we first began, it is labeled as “Main Website” under this column.

The problem is, I don’t want to MANUALLY UPDATE / Assign 6,000 products of our ~40,000 to the new website we just spun up. I want to do it via Magmi.

Hopefully that clarifies things.

Like previously stated, we have used many different variations of a file upload with different column configurations and nothing is working.

We can manually disassociate a product from BOTH websites, and can’t get a file in the correct format, to add it back to at least one via Magmi.

Thanks all for reading on the help. There has to be something small and dumb we are missing here.

Dave Furness

Founder
May 31, 2016 - 8:05 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

So in the Magmi file you are uploading you have a column for the different websites, but regardless of what you select the import isn’t working?

Is that the jist of it?

Dave

Every expert was once a beginner

group-am

Excellent
May 31, 2016 - 8:42 pm
Member Since: January 27, 2015
Forum Posts: 14
sp_UserOfflineSmall Offline

That

Dave Furness said
So in the Magmi file you are uploading you have a column for the different websites, but regardless of what you select the import isn’t working?
Is that the jist of it?
Dave  

Dave,

That is correct. We have tried a combo of different column/sheet format upload(s):

sku/store/websites
sku/store
sku/websites

The documentation of Magmi specifically states the “Websites” column is obsolete / no longer used, however we still experimented with it anyway.

The only method I have been able to work successfully is using Data Profiles, but it is just to slow, and error’s out on big uploads.

Another way we have manually been able to make it work, is selecting a group of products, then modifying them all at the same time under Product Catalog, but same thing as Data Profile’s, it takes too long and eventually times out.

Dave Furness

Founder
June 10, 2016 - 11:56 am
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

I am no Magmi Guru, but I know that Paul manages to use Magmi for multiple site, have you any other ideas Paul?

Dave

Every expert was once a beginner

 

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