|
|
-
- mikehyde
 -
Total Posts: 5
Joined: 2008-12-16
|
Hello
I am new to Magmi, and am just discovering how awesome it is - very nice work, this is the missing piece for Magento in the real world!
Quick question, and apologies if this is already answered elsewhere:
I am importing categories using the on the fly category creator. Some of my category names have an apostrophe inside like this:
Alice’s Adventures in Wonderland
These categories are getting split at the apostrophe so I am seeing a category being created just called:
Alice
I can create the categories with apostrophes via the admin interface, so is there a way to escape these characters when importing with Magmi?
Thanks a lot
Mike
UPDATE
It’s not just the category names - I am actually seeing the same effect on various fields including Product Name. If you change it in the admin area and then re-export products, the generated csv file includes the apostrophes in the right places, so it seems to be just the import process which is struggling with this.
Running Magmi 7.14a and Magento 1.5.1
|
| |
|
 |
 |
 |
|
|
-
- dweeves
 -
Total Posts: 861
Joined: 2010-06-26
FRANCE
|
@mikehyde
make sure your CSV is encoded in UTF-8 ,it\’s surely the cause of your problem.
|
| |
|
|
|
|
|
|
-
- PuxaTino
-
Total Posts: 27
Joined: 2010-08-16
|
Hi dweeves, great great job on this aplication… works quick and nice
I need to do some complex importation on Tier Pricis and I really dnt want to mess it all up…
I need to import Tier Prices which vary depending on the Customer Groups, as well, on the Store views..
So let´s say I have for sku “xxxx”:
- On Store A site, for group1=10, for group2=20, for group3=30
- On Store B site, for group1=15, for group2=25, for group3=35
and so on…
is this possible?
If so… Could you tell me the right sintax for this? I´m just a bit lost… I cant figure out how to put it and I dnt want want to break anything…
Really appreciate it
many thanx
Tino
|
| |
|
|
|
|
|
|
-
- sure24
-
Total Posts: 18
Joined: 2010-05-24
|
Hi dweeves,
Many thanks for your fast response!
I have made the changes as suggested but its not working for me.
What happens is:
* I changed the lines as requested.
* I imported everything again with original CSVs (tier_price:GROUP_NAME) as several columns in admin values CSV
* Upon inspection, there was duplicates of the tier pricing for each site
For example:
StoreA, GroupA, Price
StoreA, GroupA, Qty, Price
StoreA, GroupB, Qty, Price
StoreA, GroupB, Qty, Price
StoreA, GroupC, Qty, Price
StoreA, GroupC, Qty, Price
StoreB, GroupA, Qty, Price
StoreB, GroupA, Qty, Price
StoreB, GroupB, Qty, Price
StoreB, GroupB, Qty, Price
StoreB, GroupC, Qty, Price
StoreB, GroupC, Qty, Price
...
etc...
What should have actually been:
StoreA, GroupA, Price
StoreA, GroupA, Qty, Price
StoreB, GroupB, Qty, Price
StoreB, GroupB, Qty, Price
StoreC, GroupC, Qty, Price
StoreC, GroupC, Qty, Price
I then deleted all products from Magento DB and re-imported using your suggestion where the tier_price was imported per website as separate lines (I actually used separate CSVs) and now I get no tier_pricing at all.
Any ideas?
Update:
I had forgot to enable Tier_Price import plugin for other CSV’s.. I have done so now and currently testing import. will let you know how I get one.
|
| |
|
|
|
|
|
|
-
- dweeves
-
Total Posts: 861
Joined: 2010-06-26
FRANCE
|
@sure24
website<>store.
you should put the correct website code inside the websites column of the csv that magmi ingests.
some sample csv mockups for that
UPDATED MOCKUPS, SYNTAX WAS WRONG, DO NOT USE QTY COLUMN FOR QTY RELATED TIER PRICE
"websites","store","tier_price:_all_"
"websitecodeA","storeA","5:10.00;25:9.00;100:8.00"
"websites","store","tier_price:_all_"
"websitecodeB","storeB","5:12.00;25:11.00;100:10.00"
|
| |
|
|
|
|
|
|
-
- sure24
-
Total Posts: 18
Joined: 2010-05-24
|
Yes, it’s working!
Thank you dweeves…
I had another problem where related, cross and up-sells were not importing but from looking at the MySQL error generated it appears that you must specify a website_id for each sku so I am making those changes to my script now and about to test.
Thanks again for your help… much appreciated!
Update:
Yup, adding the column ‘websites’ and specifying all website names (comma separated) worked. Import of related, up-sells and cross-sells is now working fine.
|
| |
|
|
|
|
|
|
-
- dweeves
-
Total Posts: 861
Joined: 2010-06-26
FRANCE
|
sure24 - 03 October 2011 05:46 AM Yes, it’s working!
Thank you dweeves…
I had another problem where related, cross and up-sells were not importing but from looking at the MySQL error generated it appears that you must specify a website_id for each sku so I am making those changes to my script now and about to test.
Thanks again for your help… much appreciated!
You don’t have to set a website_id , in fact it’s calculated from websites column. the MySQL error reflects magmi internal requests, not strictly mapped to csv columns.
the good news is you don’t even have to touch the csv content.
Using default value setter or value replacer plugin, you can set the “websites” value once for all lines and this value will be applied as if it was a csv column.
|
| |
|
|
|
|
|
|
-
- sure24
-
Total Posts: 18
Joined: 2010-05-24
|
Ah, just spotted your reply after I submitted my last post…
I have added the column now but I see what you mean by using the default value setter… I will change my implementation accordingly.
Thanks again for your speedy responses!
|
| |
|
|
|
|
|
|
-
- mikehyde
-
Total Posts: 5
Joined: 2008-12-16
|
@ Dweeves
Yes! Perfect that fixed it.
Thanks a lot - still having fun exploring everything that this can do!
Cheers
Mike
|
| |
|
|
|
|
|
|
-
- dweeves
-
Total Posts: 861
Joined: 2010-06-26
FRANCE
|
For all tier price users:
tier price plugin 0.0.7 out !!! (here as usual)
Restored support for multiple websites.
updated Plugin documentation : here
|
| |
|
|
|
|
|
|
-
- sure24
-
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:
sku, store_id, store, websites, attribute_set, type, product_type_id, category_ids, has_options, name, meta_title, meta_description, meta_keyword, image, small_image, thumbnail, cost, description, enable_googlecheckout, groupscatalog_hide_group, options_container, price, short_description, status, tax_class_id, visibility, weight, qty, manage_stock, is_in_stock
Store CSV Columns are:
sku, store_id, store, websites, price, status, tax_class_id, visibility, qty, manage_stock, is_in_stock
Tier Price CSV Columns are:
sku, websites, tier_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…
|
| |
|
|
|
|
|
|
-
- dweeves
-
Total Posts: 861
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.
|
| |
|
|
|
|
|
|
-
- sure24
-
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…
|
| |
|
|
|
|
|
|
-
- dweeves
-
Total Posts: 861
Joined: 2010-06-26
FRANCE
|
@sure24 can you post some sample csv line for each of your Store CSV ?
|
| |
|
|
|
|
|
|
