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
 
sure24
Jr. Member
 
Total Posts:  18
Joined:  2010-05-24
 

@dweeves

I have still got a problem, not related to tier prices though…

The last CSV I import will always set the default (admin) price as the one specified in the CSV (for all stores)

I have 5 CSV\’s in total imported in this order:

Admin
StoreA
StoreB
StoreC
StoreD

Admin CSV columns are:

skustore_idstorewebsitesattribute_settypeproduct_type_idcategory_idshas_optionsnamemeta_titlemeta_descriptionmeta_keywordimagesmall_imagethumbnailcostdescriptionenable_googlecheckoutgroupscatalog_hide_groupoptions_containerpriceshort_descriptionstatustax_class_idvisibilityweightqtymanage_stockis_in_stock

Store CSV Columns are:

skustore_idstorewebsitespricestatustax_class_idvisibilityqtymanage_stockis_in_stock

Tier Price CSV Columns are:

skuwebsitestier_price:CUSTOMER_GROUP

I am importing the CSVs in this order:

Admin
StoreA
StoreB
StoreC
StoreD
TierPriceA
TierPriceB
TierPriceC
TierPriceD

This behaviour happens regardless of whether the Tier prices are imported or not…

Also on a side note, in the admin CSV, the custom module attribute groupscatalog_hide_group never gets imported… any way around this?

Thanks…

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

@sure24

The store column should have the “store view code” as value ,if not found, i think magmi put the “admin” store value by default.

For the special price thing, it’s a side effect from how magento works.
Magento compares the actual set price for a product to the last indexed price for it,setting it as “special price”.

After importing the last csvs, just reindex prices and all will look better.

For this:
- Create a new profile
- select “Magmi magento reindexer” plugin
- in configure , just select catalog_product_price index

you can then use magmi with this profile ,using “xcreate” (Create new,skip existing) mode so magmi will skip all records but still launching price index.

 
Magento Community Magento Community
Magento Community
Magento Community
 
sure24
Jr. Member
 
Total Posts:  18
Joined:  2010-05-24
 

@dweeves

My store column in admin CSV says:  admin

My store column for each store CSV says: storeX_store_view (where X is A to D)

But price specified in last CSV imported is always set as default (admin) value across all sites.

I am currently re-indexing everything via shell/indexer.php—reindexall

Just to note, In my configuration I have ‘per-website’ pricing setup (not global).

Thanks…

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

@sure24 can you post some sample csv line for each of your Store CSV ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
sure24
Jr. Member
 
Total Posts:  18
Joined:  2010-05-24
 

@dweeves

sure…

Here’s StoreA (retail)…

sku,store_id,store,websites,price,status,tax_class_id,visibility,qty,manage_stock,is_in_stock
11805
-1034CH-SS,1,retail_store_view,retail,26.00,Enabled,"Taxable Goods","Catalogue, Search",0,0,0
...

Here’s StoreB (trade)…

sku,store_id,store,websites,price,status,tax_class_id,visibility,qty,manage_stock,is_in_stock
11805
-1034CH-SS,2,trade_store_view,trade,9.95,Enabled,"Taxable Goods","Catalogue, Search",0,0,0
....

No point in posting StoreC or StoreD as they are identical....

Let me know if you need a copy of the Admin and I will PM it to you…

Thanks.

 
Magento Community Magento Community
Magento Community
Magento Community
 
websonica
Jr. Member
 
Avatar
Total Posts:  13
Joined:  2009-04-25
 

@dweeves

Hi,
i’m in great trouble, sometimes magmi crashes randomly in the import process (20.000) sku.

- Php does not log anything
- Apache idem at the virtual host level
- Nothing in Apache at the main error log
- Nothing in Mysql

I can’t debug the problem. Is it possible to enable globally an error reporting level to E_ALL ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
sure24
Jr. Member
 
Total Posts:  18
Joined:  2010-05-24
 

@websonica

Are you using CLI?

Could you not add to the top of ./magmi/cli/magmi.cli.php (unless it’s already enabled elsewhere and I have missed it)

error_reporting(E_ALL);
ini_set('display_errors','On');

Web UI already has this enabled in ./magmi/web/head.php on my installation.

Dave

 
Magento Community Magento Community
Magento Community
Magento Community
 
safisch
Jr. Member
 
Total Posts:  24
Joined:  2011-07-24
 

Great speed!

I’m looking for instructions on how to install the plug-ins.  Any hints?

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
safisch
Jr. Member
 
Total Posts:  24
Joined:  2011-07-24
 
safisch - 05 October 2011 04:04 AM

Great speed!

I’m looking for instructions on how to install the plug-ins.  Any hints?

Thanks

OK, no magic.  Just drop them in the Magmi plugins directory.

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

the zip files are available of sf site in plugins/packages using Files menu.
the web UI has a “upload new plugins” box on which you can directly upload the zip files.

 
Magento Community Magento Community
Magento Community
Magento Community
 
safisch
Jr. Member
 
Total Posts:  24
Joined:  2011-07-24
 

OK, as soon as I get one bug chased out, another pops up.

I’m feeding in this date for my specials: 10/3/2011

and getting this back in the product/admin area: 11/30/-1

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

Date format should be YYYY-MM-DD for date based fields.

EDIT : Next version of magmi will handle DD/MM/YYYY format as well

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

Some insights on 0.7.15

- european date format support DD/MM/YYYY in date typed fields (already on latest SVN snapshot)
- Magento Datasource for in place updates , ie : will enable to select fields & conditions for current products to be updated, combined with Value Replacer, magmi will be able to performed computed mass updates or even deletes
- Support for “store translated” select multiselect using enhanced value syntax:
storeval::[adminval]

 
Magento Community Magento Community
Magento Community
Magento Community
 
safisch
Jr. Member
 
Total Posts:  24
Joined:  2011-07-24
 
dweeves - 05 October 2011 02:27 PM

Date format should be YYYY-MM-DD for date based fields.

EDIT : Next version of magmi will handle DD/MM/YYYY format as well

Thanks.  I was trying different formats and didnt get to that one yet.  Next question:

Where do I find the field names for the magenta dataflow?  Right now all i have to go in is is the 1.5 field names.  I tried searching but can’t find any field lists or example data files.

BTW, MAGMI is an fantastic utility and an incredible piece of work.

 
Magento Community Magento Community
Magento Community
Magento Community
 
sure24
Jr. Member
 
Total Posts:  18
Joined:  2010-05-24
 

@dweeves

Was just wondering if you had chance to take a look at the price problem I had with multiple stores that I sent CSV lines for?

No pressure, your help is very much appreciated!

Thank you,

Dave

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