Try the Demo

Magento Forum

   
the quest for an efficient product import script
 
RuiMigDias
Sr. Member
 
Avatar
Total Posts:  118
Joined:  2010-10-29
 
zuiko - 27 June 2012 04:03 PM

@RuiMigDias
I don’t know really if it’s your problem but when I began to use Notepad++ I was confusing about the labelling of the menu in french (I don’t know if it’s the same in english).
To have your file in utf-8 you have to select Format / Convert to Utf-8 (without BOM).
Hope this help.

I think my issue isn’t with the file’s enconding… I think I’ve been importing ANSI encoded files all along.

Apparently I can’t change a product’s status with

sku,store,status
x001,admin,2

if the product’s status is already independent of the main website. Can someone confirm this?

For example:
I import a list of products that are active in all websites.
Later I import a file to disable it in my second store.
If I try to re-enable it using “admin” as the store value (see above), it won’t work. I need to specify the stores, instead of using “admin”.

Is there any way to reset the status value to the same value as the main website?

 
Magento Community Magento Community
Magento Community
Magento Community
 
dweeves
Enthusiast
 
Total Posts:  858
Joined:  2010-06-26
FRANCE
 
RuiMigDias - 28 June 2012 06:08 AM

zuiko - 27 June 2012 04:03 PM
@RuiMigDias
I don’t know really if it’s your problem but when I began to use Notepad++ I was confusing about the labelling of the menu in french (I don’t know if it’s the same in english).
To have your file in utf-8 you have to select Format / Convert to Utf-8 (without BOM).
Hope this help.

I think my issue isn’t with the file’s enconding… I think I’ve been importing ANSI encoded files all along.

Apparently I can’t change a product’s status with

sku,store,status
x001,admin,2

if the product’s status is already independent of the main website. Can someone confirm this?

For example:
I import a list of products that are active in all websites.
Later I import a file to disable it in my second store.
If I try to re-enable it using “admin” as the store value (see above), it won’t work. I need to specify the stores, instead of using “admin”.

Is there any way to reset the status value to the same value as the main website?

i think you can “reglobalize” the status for an item putting:

admin,storecode1,storecode2

in the store column , this will remove the dedicated status value per store for storecode1 & storecode2 (so let magento use the “admin” store value for this item status)

note that if you had your item in storecode3 , the value for storecode3 will remain store dependent wink

 
Magento Community Magento Community
Magento Community
Magento Community
 
RuiMigDias
Sr. Member
 
Avatar
Total Posts:  118
Joined:  2010-10-29
 
dweeves - 28 June 2012 06:35 AM


i think you can “reglobalize” the status for an item putting:

admin,storecode1,storecode2

in the store column , this will remove the dedicated status value per store for storecode1 & storecode2 (so let magento use the “admin” store value for this item status)

note that if you had your item in storecode3 , the value for storecode3 will remain store dependent wink

Thanks. I’ll try that.

I think I’ve found out why I was having trouble converting from ANSI to UTF-8. I need to have special characters in the text file, or it won’t change the encoding. I added “çã” to the file, changed the encoding, closed and opened it and sure enough, it was set as UTF-8.

Since I don’t have special characters in this file, I hope magmi won’t give me problems because of the encoding.

Nothing’s easy!!!!!! :D

 
Magento Community Magento Community
Magento Community
Magento Community
 
kek0
Jr. Member
 
Avatar
Total Posts:  27
Joined:  2010-03-06
 
kek0 - 05 June 2012 02:29 AM

RuiMigDias - 05 June 2012 01:39 AM
kek0 - 04 June 2012 09:33 AM
Hi! someone can help me with this question? grin

Is there any way for import the product descriptions directly from an html url source code? I am referring capturing all complete source code, I have the product descriptions in remote http url’s with tables of the specifications.

I believe you’ll need an extra tool or two for that. Try to search “html text parser” to get the text from the webpage. After that I would use something like grep, awk or perl script to get the segment I need… I’m assuming you use linux for these...

Hi! thank for your reply. I understand that actually is not implemented in magmi. I will search for the “html text parser” like you say. Thanks! smile

Hi! finally I can’t find any solution for my problem. My wholesaler provide me a CSV file and in the product description only appears an url, and in this url is only the clean code of the description of each product.

Can any help me how I can get this info inside the CSV or how use magmi for get this data directlly like the images in remote?

thanks!! smile

 Signature 

Recommended Magento Hosting. Litespeed USA/UK, very optimiced and for good price: Aspiration Hosting
http://www.dankek.com

 
Magento Community Magento Community
Magento Community
Magento Community
 
RuiMigDias
Sr. Member
 
Avatar
Total Posts:  118
Joined:  2010-10-29
 
kek0 - 28 June 2012 03:49 PM


Hi! finally I can’t find any solution for my problem. My wholesaler provide me a CSV file and in the product description only appears an url, and in this url is only the clean code of the description of each product.

Can any help me how I can get this info inside the CSV or how use magmi for get this data directlly like the images in remote?

thanks!! smile

can you provide a sample of the csv file?
If the name has undescores, you can easily switch them for spaces. You could also turn the first letter into a capital letter

Do you need to automate this process or will it be done manually? Manually, the easiest way would be using excel or similar software, I think…

 
Magento Community Magento Community
Magento Community
Magento Community
 
caitlinhavener
Jr. Member
 
Total Posts:  18
Joined:  2012-05-21
 

Hey there again! I’m still working with the import. Trying to import images. My gallery images are not showing on the front end after cache and index refresh.  CSV has header media_gallery and are formatted /image.jpg;/image2.jpg.... Inspecting the image element on the front page, it doesn’t look like its pointing to any particular image in the cache… So, I’m trying to figure out why that image doesn’t show up.

It’s pointing to where the image should be in back end… click into the link says link is broken. I manually put the applicable images in product folder and then they showed up.  So problem seems to be image import into that folder.

I get error for my gallery images:
Image attributes processor v1.0.22 - error copying /home/aaadmin/public_html/store/magmi/media/catalog/product/// : 2,copy() [function.copy]: The first argument to copy() function cannot be a directory

The last import I ran, the pictures only show up in the list as shown: http://alluringassets.com/store/costumes.html
but not in detail page: http://alluringassets.com/store/costumes/chamber-maid.html

Help would be much appreciated!!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
fritzelly
Member
 
Total Posts:  53
Joined:  2010-07-13
 

I’m just setting up a new store using the same database. I’ve added a store column and added my two store views (using the ‘store name’)seperated by a comma but nothing gets added into the second store
Am I doing this right?

 
Magento Community Magento Community
Magento Community
Magento Community
 
drknickel
Member
 
Total Posts:  32
Joined:  2010-09-03
 

Hello everyone,

i really love magmi, now i want to take it to the next level smile At the moment i have two problems:

1.)
I need to update Magmi from version 0.7.16 to 0.7.17. Normally i would only overwrite all the magmi files, but now i guess something has changed. I cant find a update magmi section in the wiki, the only info is in the sourceforge download section, but it is only for the beta.
See here: http://sourceforge.net/projects/magmi/files/magmi-0.7/releases/
Is this info correct if i update from 16 to 17 directly, too?

2.)
My biggest problem is that i now have different inventorys for different stores.
I have two stores, A and B.

I have three CSVs: Together, A and B.

I first import the values of Together, then i want to import A and B. A info should only show up in store A etc.

How do i do this in the best way? The website value is obsolete in the new version, right?

Thank you so much for your help,
greets

 
Magento Community Magento Community
Magento Community
Magento Community
 
RuiMigDias
Sr. Member
 
Avatar
Total Posts:  118
Joined:  2010-10-29
 
drknickel - 02 July 2012 12:41 AM


How do i do this in the best way? The website value is obsolete in the new version, right?

Thank you so much for your help,
greets

Yes. Use the “store” name. It will assign the values to the website.

 
Magento Community Magento Community
Magento Community
Magento Community
 
RuiMigDias
Sr. Member
 
Avatar
Total Posts:  118
Joined:  2010-10-29
 
fritzelly - 01 July 2012 02:50 PM

I’m just setting up a new store using the same database. I’ve added a store column and added my two store views (using the ‘store name’)seperated by a comma but nothing gets added into the second store
Am I doing this right?

You should use the code, not the store name.

Besides, if you want to add the same info to all the stores, you should use “admin” as the store code. That will prevent duplicated info.

 
Magento Community Magento Community
Magento Community
Magento Community
 
drknickel
Member
 
Total Posts:  32
Joined:  2010-09-03
 
RuiMigDias - 02 July 2012 01:03 AM

drknickel - 02 July 2012 12:41 AM


How do i do this in the best way? The website value is obsolete in the new version, right?

Thank you so much for your help,
greets

Yes. Use the “store” name. It will assign the values to the website.

Great, thanks for your reply. What about the update? What is the best way to update? I guess i have to update before i can use this feature.

smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
RuiMigDias
Sr. Member
 
Avatar
Total Posts:  118
Joined:  2010-10-29
 
caitlinhavener - 29 June 2012 02:39 PM

I get error for my gallery images:
Image attributes processor v1.0.22 - error copying /home/aaadmin/public_html/store/magmi/media/catalog/product/// : 2,copy() [function.copy]: The first argument to copy() function cannot be a directory

have you tried removing the “/” from the file names?

 
Magento Community Magento Community
Magento Community
Magento Community
 
RuiMigDias
Sr. Member
 
Avatar
Total Posts:  118
Joined:  2010-10-29
 
drknickel - 02 July 2012 01:06 AM


Great, thanks for your reply. What about the update? What is the best way to update? I guess i have to update before i can use this feature.

smile

Just install the new version in a new folder. It shouldn’t be too hard to replicate your original settings…

 
Magento Community Magento Community
Magento Community
Magento Community
 
drknickel
Member
 
Total Posts:  32
Joined:  2010-09-03
 
RuiMigDias - 02 July 2012 01:17 AM

drknickel - 02 July 2012 01:06 AM


Great, thanks for your reply. What about the update? What is the best way to update? I guess i have to update before i can use this feature.

smile

Just install the new version in a new folder. It shouldn’t be too hard to replicate your original settings...

Ok, thanks for your help smile

Greets

 
Magento Community Magento Community
Magento Community
Magento Community
 
drknickel
Member
 
Total Posts:  32
Joined:  2010-09-03
 

Hello RuiMigDias,

thank you so much for your help. I was able to update to magmi 0.7.17 but i still cant manage to update the values for a specific store.

Here is what i want to do:

- admin.csv <- The basic CSV with all SKUs in it, all the data.
- store_a.csv <- here i only want to update quantaty (qty) based on SKU, nothing else.
- store_b.csv <- here i also want to update quantaty (qty) based on SKU, nothing else.

First, the admin.csv runs, everything is ok.

Then the store_a.csv runs, with Value replacer set to magmi ignore to every value exapt STORE, SKU and QTY.
The value gets updated, but for every store not just store_a. I use the store code.

What am i doing wrong?

Thanks for your help,
greets

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