Magento

Also, when importing products via csv or API, does magmi trigger Observer events? in particular the cataloginventory_stock_item_save_after events.

Cheers.

Hi all,

I’ve just encountered another issue. When I tried with Datapump API to import simple+configurable products, an error page shown with the error of SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘cat_index_position’ in ‘order clause’

I have CE 1.7.0.0, and I tried with CSV and it is still not working

Anyone have any insights?

Cheers

mengqing - 02 July 2012 07:30 PM

Also, when importing products via csv or API, does magmi trigger Observer events? in particular the cataloginventory_stock_item_save_after events.

Cheers.

No , magmi does not call magento code at any time, does not share any code with magento. it’s been done “on purpose”.
Magento Events are unpredictable in terms of time (in fact, that’s what takes the most time in the magento standard import)
you could call the observer in your script if you want since you use Datapump API.

Dweeves,
I tried the method you said and I it added both categories to the root of each store, it didn’t seem to notice that the root was already in the columns category path
Do you actually have to add the square brackets?
Tried it with and without and didn’t make any difference.

An update, think I had an old plugin but now I get for the multi store
Cannot find site root with name : Store_1]/Treats/Chocolate;;[Store_2

and for the single store
Cannot find site root with name : Store_1

I’m having an annoying problem with the permissions and I’m finding it hard to find the solutions.

I’ve managed to set the error reporting to 0 in the head.php file, but I still get session errors when I’m trying to process the thing.

It’s really annoying because i’m getting magmi errors (I’m trying to import some images using the attribute thing) and I can’t see them, because all I see is what’s in the attached image.

The errors are:

Warning: session_start() [function.session-start]: open(/tmp/sess_cc6d42ab5625dcff9bb0df19c3e37dd2, O_RDWR) failed: Permission denied (13) in /####/magmi/web/magmi_progress.php on line 32

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /####//magmi/web/magmi_progress.php:32) in //####/magmi/web/magmi_progress.php on line 32

Warning: session_write_close() [function.session-write-close]: open(/tmp/sess_cc6d42ab5625dcff9bb0df19c3e37dd2, O_RDWR) failed: Permission denied (13) in //####//magmi/web/magmi_progress.php on line 35

Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in //####//magmi/web/magmi_progress.php on line 35

Cheers,
Tom

Click thumbnail to see full-size image

Right, must be a server thing. I utilized the ‘session_save_path’ function and defined my own writeable directory.

I don’t get why this is happening to only magmi as I’ve got a whole functioning magento store in the same folder!

Anyway, that seemed to sort it for me

Thanks,
Tom

Hi,

I have a problem when using Magmi for configurable product. I handle 2 languages : french (admin), and english.
I use a dropdown attribute called “choix”, and I am trying to use this method to handle proper translation of values:

My attribute is set to global, required.

French(admin) - create mode-

English - update mode-

Magmi doesnt seems to recognize this as a single value translated. It creates 6 independent values instead.

The question is: does this methods can handle configurable attributes / dropdown ?

If no, how can I get the translation done with Magmi?

Thanks

Got it working with a single root category, it was only when I went to store view that I saw the root category was still set as Default Category, even though I changed it all All Store Views
Still not working with multi root categories, the regex does not match properly where you have two root categories or should these be already split by the ;; when it enters that function?

Hi all

Having an issue using REGEX in the product relater and cross-sell/upsell plugins. My SKU’s are sonething like this:

BCS/P/D/004/24/AL

Where BCS refers to the type of product, and AL refers to a configurable option. Therefore, the configurable version of the simple product above will be:

BCS/P/D/004/24

Now, I want to relate (and cross/up sell) products within the BCS range with each other - but NOT the simple variants (for some reason, even though the simples are set as ‘not visible individually’, they still show as relates and cross/upsell products). So, I figured I would have to run 2 passes with the CSV file - one to associate all the products and simples, and one to un-associate the simples (I have MANY variants for the configurables so it is unmanageable to list just the ones I want related in the ‘re_skus’, ‘cs_skus’, and ‘us_skus’ columns). So, my two CSV files have the appropriate columns set as something like this:

file 1: Sets the associations - simple variants included:

re::BCS/.*

This works as expected - so the products end up with all the variants within a range related. So, then I run a second script with the following set, to remove the associations with the variants:

-re::BCS/.*./AL

However, instead of removing just the simple SKU detailed above, it removes ALL associations.... (I have also tried the following regex: -re::BCS/.*/AL)

Not what I want at all!

Any suggestions where I am going wrong??

Simon

Bug report

Hi Dweeves,

As discussed here with Zuiko on the Fragento forum : Fragento

Magmi doesnt handle global attributes when using the syntax storeval::[adminval], so it creates separate values, not translated values.

When debugging, on line ~481, magmi allways enter the if(storeId==0) (admin store), so for him, there is no other stores than the admin one. On the DB, storeIds are always the same.

I’ll try to give you more info on that during the day as I am testing a temporary workaround to get it work for us, waiting for you to investigate for a permanent fix.

Thanks!

I just uploaded this script to another server and for some reason when I save the following under CSV options
CSV separator: | and the CSV Enclosure:”

It comes back as:
CSV separator: | and the CSV Enclosure: \”

So I tried re-entering CSV separator: | and the CSV Enclosure:” .....................but it just keeps saving as above, and when I delete the fields to leave them blank it comes blank so it’s obviously saving.

I’ve never experienced this before with Magami or any other server, is there something that is missing permissions perhaps or a file that I need to change for this unique situation?

@magentosuccess

i think the magic_quotes_gpc setting is On on the server but magmi requires this setting to be set to Off.

I checked the .htaccess in the root and it’s set to off

php_flag magic_quotes_gpc off

Any other suggestions you might have? Thanks for the help.

A product’s price is 124.85, but if I select a size, it changes to 124.84. Does anyone have a clue why this happens?

The configurable product’s base price is 101.50 and the VAT is 23%. This equals 124.845… What’s happening?

Simple’s price is set to “0” in super product attributes configuration. I’m assuming the simple product’s prices are irrelevant…

@RuiMigDias
it’s surely a rounding issue.