Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

the quest for an efficient product import script
 
dweeves
Enthusiast
 
Total Posts:  877
Joined:  2010-06-26
FRANCE
 

@paderEpiktet

I’m really glad Magmi helped you finalizing your project.
Hope you’ll find some time to write about it on a blog explaing how magmi helped you and how it integrated in your workflow.

 
Magento Community Magento Community
Magento Community
Magento Community
 
TSK
Jr. Member
 
Total Posts:  23
Joined:  2009-07-06
 

hi,
i have an issue with multi-store view import ..my csv is looks like this

store;attribute_set;websites;type;sku;short_description;description;cost;price;status;visibility;is_in_stock;name;tax_class_id;qty;weight;category_ids;image;small_image;thumbnail;color;size;manufacturer;special_from_date;special_to_date;special_price;internalsku;url_key;news_from_date;news_to_date;color_code
en
;Default;base;simple;sku-37013;Twitch75cm ENGLISH;Twitch75 cm.;11;24.95;Enabled;1;1;Twitch75 cm.;BTW 19%;0;1;21;/5039 a.jpg;/5039 a.jpg;/5039 a.jpg;wood;75cm;QHP;;;;5039BE75;;;;
nl;Default;base;simple;sku-37013;Twitch75cm DUTCH;Twitch75 cm.;11;24.95;Enabled;1;1;Twitch75 cm.;BTW 19%;0;1;21;/5039 a.jpg;/5039 a.jpg;/5039 a.jpg;wood;75cm;QHP;;;;5039BE75;;;;
 
Magento Community Magento Community
Magento Community
Magento Community
 
dweeves
Enthusiast
 
Total Posts:  877
Joined:  2010-06-26
FRANCE
 
TSK - 04 July 2011 02:18 AM

hi,
i have a problem with multi-store view import ..my csv is looks like this

store;attribute_set;websites;type;sku;short_description;description;cost;price;status;visibility;is_in_stock;name;tax_class_id;qty;weight;category_ids;image;small_image;thumbnail;color;size;manufacturer;special_from_date;special_to_date;special_price;internalsku;url_key;news_from_date;news_to_date;color_code
en
;Default;base;simple;sku-37013;Twitch75cm ENGLISH;Twitch75 cm.;11;24.95;Enabled;1;1;Twitch75 cm.;BTW 19%;0;1;21;/5039 a.jpg;/5039 a.jpg;/5039 a.jpg;wood;75cm;QHP;;;;5039BE75;;;;
nl;Default;base;simple;sku-37013;Twitch75cm DUTCH;Twitch75 cm.;11;24.95;Enabled;1;1;Twitch75 cm.;BTW 19%;0;1;21;/5039 a.jpg;/5039 a.jpg;/5039 a.jpg;wood;75cm;QHP;;;;5039BE75;;;;


What is wrong with the CSV ?

What is exactly your problem, “i have a problem” is a little bit short to analyze.

 
Magento Community Magento Community
Magento Community
Magento Community
 
TSK
Jr. Member
 
Total Posts:  23
Joined:  2009-07-06
 

Hi dweeves,

i have multi language store.

i have given the attribute values to specific store views like below. But this was not imported to specific languages.

how to import attribute values to different store views?

store;.........color;size;manufacturer
en
;.............red;95cm;BHP;
nl;..............wood;75cm;QHP;
 
Magento Community Magento Community
Magento Community
Magento Community
 
dweeves
Enthusiast
 
Total Posts:  877
Joined:  2010-06-26
FRANCE
 

HI TSK, As said here in the wiki:

Magmi does not create “multilanguage” values but will create one value per store.
At the end,the result will be the same on frontend, but on the admin side, you won’t see “translated” value.

The explanation is simple:
With a single value in the column, there is no way to know which “translation” of other value it could be.

I explain this some posts before.

 
Magento Community Magento Community
Magento Community
Magento Community
 
xenix
Jr. Member
 
Total Posts:  4
Joined:  2011-03-16
 

Magmi works great for me for simple products, and for configurables - i have one slight problem.

I can’t force “Not Visible Individually” in the configure mode, when i click save profile; it does not save.

After importing products - I have to go edit manually the simples so that it doesn’t show up.

How do i fix this bug, or if it’s a mistake on my part ?

Thanks for an excellent script !

 
Magento Community Magento Community
Magento Community
Magento Community
 
dweeves
Enthusiast
 
Total Posts:  877
Joined:  2010-06-26
FRANCE
 

@xenix : which version are you using ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
xenix
Jr. Member
 
Total Posts:  4
Joined:  2011-03-16
 

v0.7.12rc1

Configurable Item processor v1.3.2

 
Magento Community Magento Community
Magento Community
Magento Community
 
dweeves
Enthusiast
 
Total Posts:  877
Joined:  2010-06-26
FRANCE
 

got your PM, will inspect this later this evening.
surely a plugin parameter name mismatch between UI & plugin class that prevents saving.

 
Magento Community Magento Community
Magento Community
Magento Community
 
dweeves
Enthusiast
 
Total Posts:  877
Joined:  2010-06-26
FRANCE
 

magmi configurable plugin 1.3.2a released, thanks xenix, i found a typo in plugin options panel preventing save of force simple visibility parameter.

latest plugin available here as usual

0.7.12 about to be released very soon, since latest add in core is done (support for relative qty updates wink )

@xenix: your setup is already up to date with latest version of configurables plugin.

 
Magento Community Magento Community
Magento Community
Magento Community
 
xenix
Jr. Member
 
Total Posts:  4
Joined:  2011-03-16
 

thanks a ton !

i’ll give this one ago - your script is a real lifesaver !

 
Magento Community Magento Community
Magento Community
Magento Community
 
xenix
Jr. Member
 
Total Posts:  4
Joined:  2011-03-16
 

everything works now, thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
dweeves
Enthusiast
 
Total Posts:  877
Joined:  2010-06-26
FRANCE
 

0.7.12 to be released tomorrow, time for me to update the docs.

Here is the release Notes that lists the enhancements from 0.7.11

Most are already available in latest released plugins & in 0.7.12rc1

-------------------------------------------------
- RELEASE NOTES FOR MAGMI 0.7.12 -
-------------------------------------------------

##########
#Bugfix
#########
- fixed attribute scanning conditions (typo was setting always true)

##########
#Core
##########

* ProductImportEngine

- added relative category affectation.
- added store column check warnings
- added support for no store column, defaulting to “admin”
- getAttrInfo can now perform DB lookup if not cached instead of returning empty
- added support for explicit relative values in qty column for stock updates

* Magmi_utils
- added utility functions trimarray & getRelative

############
# UI
############

- Added parameter change detection, if no plugin have changed, profiles can be run using new parameters without saving.
- Better ajax callback for progress check.
- Utilities UI totally revamped, more coherent with lma

###############
# Integration
###############

- added new sample for configurable trough Datapump

#########
#Plugins
#########

Base:
------

* CSV Datasource:
- CSV download now takes live value for csv combo.
- Now allows truncated CSVs (where some lines ends before the end of declared header columns), added related UI option

* SQL Datasource
- Fix for short open tags in options_panel

* Configurables:
- Updated related simples visibility modification policy (now all values are possible)
- Better management of unknown options_container if forgot to use generic mapper for translated values, now cleanly defaults to “Block After Item Info”
- fixed compatibility bug with custom options that was also manipulating options_container value
- Added warning if no configurable attributes are defined on the configurable line or could not be deduced from attribute set

* Product Deleter:
- new plugin that enable to delete products, just add a magmi:delete column & put 1 on each product line to delete

* Product relater & cross/upsell:
- autoclean double relations that might have cause related to not show up.

Extra
-----

* Categories
- added support for custom tree branch separator
- added support for relative add/delete of categories assignment of item
* Image Processor
- added support for “per store” labels for gallery
- added support for https urls
- bugfix for file kept open on remote urls
* On the fly indexer
- fix problem when reindexing item that was “logically cancelled” by processing.

* Value Replacer
- added support for {meta.xxx} value that will get some info on item status (new,same,product_id)



* Value Replacer

Utilities
---------

CleanEAV:
- EAV status check now an action ,not performed on loading

Clear Products:
- added link tables clear

Custom SQL:
- added page layout cleaning if wrong values imported
- added orphan options removal

 
Magento Community Magento Community
Magento Community
Magento Community
 
dweeves
Enthusiast
 
Total Posts:  877
Joined:  2010-06-26
FRANCE
 

magmi 0.7.12 out!!! (here as usual)
extra package updated
utilities packages updated
(both here as usual)

The long path of test, enhancements & validation has come to an happy end , the latest magmi release is out.

As the release notes let appear, many improvements have been done both on UI behaviour & plugin capabilities.

I’m currently editing the wiki , adding many interesting details.

Thanks to all for suggestions & reports , special thanks to zuiko for testing.

Enjoy !

 
Magento Community Magento Community
Magento Community
Magento Community
 
miva
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2009-10-14
 

Hi Folks;

I’ll new to magento and magmi, magmi is a great product, unfortunately I can’t seem to get an upload/import to happen, thou they do work with dataflow. I suspect rookie mistakes. I keep getting the error cannot create product sku:, no attribute_set defined. but I do Have a attribute set - default. Any help greatly appreciated.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top