Magento

I’ve imported 10k products with Magmi but the categories are not linked to the products.
I used the category name extension, so the categories appear and in the admin the categories show X# of products, but the frontend won’t display them.

Any help greatly appreciated.

Chris

Hi

When I try to import files, it tells me it was successful and 38/38 but I don’t see the products on the front or back end.  I’ve re-indexed and cleared cache, but the products are not there. 

Is there something obvious this might be?  Where in the database to I look to check if the products are actually there somewhere?

Thanks in advance.

Magento 1.7
Magmi v0.7.17a

Hello, I’m probrando MAGMI and is amazing, I even made a donation!

But I can not create an item in the store that I say to csv, I always create the item in every store, I think that is why not use either csv, but I’ve done every test possible and not consiguo, I can do wrong?

This csv:

“store” “sku” “ name” “category_ids” “manufacturer” “status” “tax_class_id” “price” “cost” “pro” “alm” “may” “qty” “is_in_stock”
“admin,dieltroncom” “NUBI4” “Tablet Android 7in nubi4 SpcInternet” “537” “SpcInternet” “1” “IVA18” 84.66 62.88 78.60 75.00 75.00 0 “1”

Create the article in the shops “dieltroncom” and “dieltrones” but only “dieltroncom” I’ve tried multiple variations always with the same result.

Help, please

JerseyBoy - 03 August 2012 11:59 AM

I’ve imported 10k products with Magmi but the categories are not linked to the products.
I used the category name extension, so the categories appear and in the admin the categories show X# of products, but the frontend won’t display them.

Any help greatly appreciated.

Chris

Check in admin to make sure the status is set to “enabled” and visibility should be at least “catalog”

wizer - 05 August 2012 06:13 AM

Hi

When I try to import files, it tells me it was successful and 38/38 but I don’t see the products on the front or back end.  I’ve re-indexed and cleared cache, but the products are not there. 

Is there something obvious this might be?  Where in the database to I look to check if the products are actually there somewhere?

Thanks in advance.

Magento 1.7
Magmi v0.7.17a

go to admin panel, catalog > manage products. Do they show up there? If so check what I said above (status and visibility)

Hi

Thanks for taking the time to reply.

No I do not see them at all on the back end.  Nothing.  I’ve tried all types of searches.  The number of products does not increase, even though Magmi says 38/39 Imported.

@ososoft

are your 2 stores under the same website ?

if yes : in magento, product is bound to a website (not a single store)

if you want it not to appear in a given store (under same website) , the most efficient way is :
- create a second csv with just product sku & status column (set to disabled)
- run magmi in “update” mode

the product will be disabled for this store.

if no : this might be a bug, but first time it is reported.

Hi All,

Just want to try again since my original request got lost on a load of other replies.

Basically, I’m uploading images and multiple images perfectly. Everything’s great except on some products, the Base Image is sometimes not set. The same happens with the thumbnail sometimes. The only consistent one is the small image.

It’s too inconsistent to point out a problem. Sometimes it’s one, sometimes it’s the other.

I can’t work out why it does it. I use the remote downloader, as it’s a massive load off my server.

Can anyone suggest a solution? Is there a way I can set it in the actual magento database itself?

Your help would be much appreciated.

tomharding - 06 August 2012 02:06 AM

Hi All,

Just want to try again since my original request got lost on a load of other replies.

Basically, I’m uploading images and multiple images perfectly. Everything’s great except on some products, the Base Image is sometimes not set. The same happens with the thumbnail sometimes. The only consistent one is the small image.

It’s too inconsistent to point out a problem. Sometimes it’s one, sometimes it’s the other.

I can’t work out why it does it. I use the remote downloader, as it’s a massive load off my server.

Can anyone suggest a solution? Is there a way I can set it in the actual magento database itself?

Your help would be much appreciated.

Worked it out.

http://www.magentocommerce.com/boards/v/viewthread/222593/#t307804

There’s a direct SQL query here you can use to achieve this.

Maybe one day this could be incorporated into Magmi? Don’t know how tough that will be, but it would be awesome if there was a way to include this in my daily upload.

Thanks!

DavorNo - 02 August 2012 12:13 PM

RuiMigDias - 02 August 2012 05:54 AM

DavorNo - 02 August 2012 03:21 AM

Hmmm… Tnx for replay. I put on magmi dir and all subdir permission on 777 (only dir not files). I have setup htaccess like yours (in magmi dir) but I still got error 404 when I try to open www.domain.com/magmi/ and www.domain.com/magmi/web/ and www.domain.com/magmi/web/magmi.php?!

I would copy magmi again. Do it via FTP. You can use a new folder to test ("magmi2").

magmi2/conf , magmi2/state must be writeable..

edit: I’m sorry, I just saw that you have normal access to magmi without the htaccess file. That means it’s not a file permissions issue.... unless it’s with the htaccess file itself. Try chance it’s permissions to 644.

I try to change permissions on dirs and files, only with 755 I get access to magmi.php, all other values I got error 404 page. And with permission set to 755, when I back htaccess in magmi/web, again I get error 404. My root htaccess have no changes, and I use magento 1.6.1.0.

Solution is to put:

ErrorDocument 401 “Unauthorized access”

in htaccess of magmi dir. Tnx for effort, and I hope this will help to others with similar problem.

Hy,

I have a bit of a problem with magmi… It kind of brakes my dates. I mention that i edit my csv in excel and I run magento 1.6.2. The problem is that my dates are set like 10.08.2012, and the promo products are set the same. When i do an import with magmi some remain ok… but 99% of the dates break… they are set to 10.08.2007 or 2002, and so on. Does anyone have any suggestions? Thanks

This is an amazing plugin! Thanks to Dweeves for all the hard work.

So I’ve got the import working perfectly, and have created a SSIS package that gets the data into the right format and exports it. I have combined this with a folder synchronisation program to get all my images and magmi csv onto my web server ready to be imported.

I’m guessing my next step to creating an entirely automated environment between our local stores database and our magento database is to create some kind of script that:

Calls the SSIS package
Waits till it complete
Calls the folder synchronisation program
Waits for it to complete
Calls Magmi via the CLI or WGET or CURL?
Waits for it to complete

Are there any resources about how I should go about creating this script? (Can I accomplish all of this in something as simple as cmd or are there easier / more powerful ways?)
Should I use CLI, WGET or CURL?
Thanks!

Hi Guys,

Love this extension!

I am having a few problems though, wondered if anyone could possible help?

1. I can’t use remote csv files if the URL isn’t a direct link to a CSV file. For example my remote URL is http://www.example.com/download.php?u=23213&password;=34f34fe3f3&export;=csv

This downloads the CSV if you visit it in the browser, but magmi seems to want a full path to an actual CSV file.

Any way to modify this?

2.  ***FIXED***MY FILE WAS SAVED AS ANSI ENCODING, NEEDS TO BE UTF-8.

Magmi doesn’t import £ signs, I can import $ signs, but it will break and ignore the rest of the field if there is a £ in there somewhere.

3. ***FIXED***IT DOES WORK, MY FEED HAD 2 SPACES INSTEAD OF 2 BETWEEN THE DATE AND TIME. USED MAGMI VALUE REPLACER TO FIX.

It doesn’t work with this module. http://www.magentocommerce.com/magento-connect/scheduled-products-5808.html

I try to import the start and end dates and magmi just seems to ignore it?

If anyone can help I would be much appreciated. I dont mind buying you a drink via paypal either!

Cheers,

Mike

Hi,

is there any chance to import Group Price (I think new attributes form 1.7 CE)? Tier price plugin says:

EDIT: is there a possibility to Clear categories? (like clear catalogue in advanced utilities). It would be nice to run that to put magent ointo default empty status (product and categoreis).

Dweeves - This is a lifesaver!!  what used to take over 24 hours to do , import over 78,000 items, now only takes an hour.
I do have one question, since I deal with books, I need to have the isbn number imported and it did not do that.  Any ideas why and how I can fix this?

During upload of my file, I get this error.  I cant figure out why… does someone know the solution?

Error:

Upload file: