Magento

to dweeves
i cant to post with attsach, so here is link to my test file wtih headings
http://dl.dropbox.com/u/1645583/import2.csv

to dweeves:

I’ve been looking what effect the multistore/websites have on the data too.

Here’s our setup:

store id 0: base (admin values)
store id 1: Website 1 - store 1 - view = Dutch
store id 2: Website 1 - store 1 - view = English

store id 3: Website 1 - store 2 - view = Dutch (Store 3 has different kinds of items)

store id 4: Website 2 - store 1 - view = Dutch (WEBSITE 2 has different pricing!)

SKU 00012 (entity_id 76938) is available in storeid 1,2 and 4

in catalog_product_website it has entries for website_id 1 (base) and 2 (b2b)

breakdown of the changes made in DB: (as far as I could find)

example value: NAME (catalog_product_entity_text - attribute id 57)
backend settings: scope=store_view
by default (in our setup) Magento sets an imported item at it’s base value (store id 0)

catalog_product_entity_text:
attribute_id 57
store_id 0
value: NAME

Depending on the product settings, item is now available in all views
if you change the title in the English store view (storeid 2) (untick use default value box for selected store view in backend, change name) , it adds a line in the catalog_product_entity_text DB:

catalog_product_entity_text:
attribute_id 57
store_id 2
value: NAME FOR ENGLISH VIEW

it only seems to add a line for the entry needed (so no extra line for the other views - just storeid 0 (=base) and storeid 2 (=english) - the others are taken from the baseview

When you edit the product in the backend to change the Name back so it uses the default value (in store view for storeid 2, tick Use Deafult Value ON again), then it removes the entry from the DB again

Example 2: price (scope=website)
we have 2 prices - 1 for website 1 (use base/admin values), 1 for website 2 (storeid 4)
in catalog_product_entity_decimal:

storeid = 0, value = PRICE A
storeid = 4, value = PRICE B

I couldn’t create an export for all values in 1 export file (maybe it’s me, maybe it’s magento settings..)

hope this helps

Thanks for getting me data guys, should be able to get a new release this afternoon.

For multiple stores or websites you just need to respecify attribute values that has scope \"store view\” if you want them to change.

If you don\’t specify a value for a \"store view\” attribute , for example product name, the value taken will be the \"admin\" value.

So you upload first product line with all \"admin\" values and then a second product line, with the same SKU, and values you want to change.

In my own case I want to specify a new price, a new url key, a new short description and description.

Inventory is \"global\" so I don\’t redefine inventory attribute (otherwise they are overwritted even if the field is leaved blank).

Here\’s an example of a csv for my website : 2 websites, with one store view each.

The first one extraction_article_de.csv witch set \"admin values\” (dropdown attributes codes, inventory etc..) that I can use for most websites / store views.

The second one extraction_article_de2.csv witch set \"store view\” specific values (product name in correct language, price, description...)

Hope this helps.

You just forgot to attach the files , you can send them to be by mail if you want

Hi Folks,

I assume not as I cant see it mentioned, but can anyone confirm if this script will help with:

A) Importing Categories
B) Importing Tiered Pricing
C) Importing Attribute Sets

Irrespective I will take a look to see if it helps with the base import - 15,063 products to do! (Single Store view, 400+ categories, 20 attribute sets, 100+ attributes).

Cheers,

Mizpah

This script only import products .

but if you have already defined your attribute sets/categories & attributes in magento it will correctly map all your products on it.

moreover,if you use multiselect or select attributes, you don’t need to predefine option values in magento, the script will create them automagically.

[SOLVED]

=====================
it whose problem whit PDO used in php v5.2.9…

---------
Mr Lei

updated 0.2.11

- minor fixes
image editing on the backend
enhancement for reset SQL exception (should not appear now)

0.3 will come later than expected, need to setup multi store on my dev site an see how it goes.
however , the 0.2.11 has already some multi store experimental code, if some adventurous testers want to make a test but i doubt it’s already working.

magento_mass_importer.zip  (File Size: 11KB - Downloads: 218)

new release 0.3 !!!!

- multiple store support (using magento syntax , one line per product & per store, you can leave empty values for values not changing from base store)

magento_mass_importer.zip  (File Size: 11KB - Downloads: 231)

[SOLVED]

[Problem]
I have problem whit my polish fonts…
When i import use MassImport a have broken polsih fonts, in the same file i used to norma import in System -> Import/Export->Profile and them fonts is ok.

i’m trail chang in import() method:

#setlocale(LC_ALL,"en_US.UTF-8");
--> setlocale(LC_ALL,"pl_PL.UTF-8");
but it’s don’t work.
=========================

[SOLUTION]

i change initialisation in PDO add --> array(PDO::MYSQL_ATTR_INIT_COMMAND => “SET NAMES utf8")
and erase force UTF8 chars ..

and All Polish words work great and very fasssssst

Mr Lei

To Mr Lei:
be sure to save your csv input file in UTF-8 since i don\’t perform input encoding detection yet.

To dweeves:

yes… UTF-8 and this file work ok in Import in System -> Import/Export->Profile…

updated version 0.3.1
- binary reading for csv (should fix mr Lei issue)

magento_mass_importer.zip  (File Size: 11KB - Downloads: 289)

To dweeves:

...don’t work form me.
i don’t now where find?

Mr Lei