Import 2500 goods, have only name and price

[mokro]

Hello, i am generate xlsx file and convert to cvs for import goods
During the xlsx generation, I noticed that some columns are not needed for importing, because it's hard to generate so many columns automatically. Once I did manage to leave columns with a name by the price category by availability and stock and something else, but I accidentally deleted this file.

What columns are needed to load a large amount of goods, and then I can further edit into the joomla?

id title alias sku ean price price_original price_groups price_histories tax categories manufacturer upc jan isbn mpn serial_number registration_key external_id external_key external_link external_text access groups featured video public_download_file public_download_text description description_long image images attributes specifications discounts related stock stock_calculation stockstatus_a_id stockstatus_n_id min_quantity min_multiple_quantity min_quantity_calculation length width height weight volume unit_amount unit_unit points_needed points_received point_groups published language date tags metakey metadesc

I used kind of: title price categories access groups featured stock stock_calculation stockstatus_a_id stockstatus_n_id published language
and it work, plus some more

[Jan]

Hi, just create one product in administration and export it so you will see the columns.

Database columns:

Code: Select all

id;title;alias;sku;ean;price;price_original;price_groups;price_histories;tax;categories;manufacturer;upc;jan;isbn;mpn;serial_number;registration_key;external_id;external_key;external_link;external_text;access;groups;featured;video;public_download_file;public_download_text;description;description_long;image;images;attributes;specifications;discounts;related;stock;stock_calculation;stockstatus_a_id;stockstatus_n_id;min_quantity;min_multiple_quantity;min_quantity_calculation;length;width;height;weight;volume;unit_amount;unit_unit;points_needed;points_received;point_groups;published;language;date;tags;metakey;metadesc

Titles:

Code: Select all

ID;Title;Alias;SKU;EAN;Price;"Original Price";"Price Groups";"Price History";"Tax Rate";Categories;Manufacturer;UPC;JAN;ISBN;MPN;"Serial Number";"Registration Key";"External Product ID";"External Product Key";"External Link";"External Link Title";Access;Groups;Featured;"Video URL";"Public Download File";"Public Download File Title";Description;"Description (Long)";Image;"Additional images";Attributes;Specifications;Discounts;"Related Products";"In Stock";"Stock Calculation";"Stock Status (Product > 0)";"Stock Status (Product = 0)";"Minimum Order Quantity";"Minimum Multiple Order Quantity";"Minimum Quantity Calculation";Length;Width;Height;Weight;Volume;"Unit Amount";Unit;"Points Needed";"Points Received";"Point Groups";Published;Language;Date;Tags;"Meta Keywords";"Meta Description"

Jan

[mokro]

Hi, just create one product in administration and export it so you will see the columns.

Database columns:

Code: Select all

id;title;alias;sku;ean;price;price_original;price_groups;price_histories;tax;categories;manufacturer;upc;jan;isbn;mpn;serial_number;registration_key;external_id;external_key;external_link;external_text;access;groups;featured;video;public_download_file;public_download_text;description;description_long;image;images;attributes;specifications;discounts;related;stock;stock_calculation;stockstatus_a_id;stockstatus_n_id;min_quantity;min_multiple_quantity;min_quantity_calculation;length;width;height;weight;volume;unit_amount;unit_unit;points_needed;points_received;point_groups;published;language;date;tags;metakey;metadesc

Titles:

Code: Select all

ID;Title;Alias;SKU;EAN;Price;"Original Price";"Price Groups";"Price History";"Tax Rate";Categories;Manufacturer;UPC;JAN;ISBN;MPN;"Serial Number";"Registration Key";"External Product ID";"External Product Key";"External Link";"External Link Title";Access;Groups;Featured;"Video URL";"Public Download File";"Public Download File Title";Description;"Description (Long)";Image;"Additional images";Attributes;Specifications;Discounts;"Related Products";"In Stock";"Stock Calculation";"Stock Status (Product > 0)";"Stock Status (Product = 0)";"Minimum Order Quantity";"Minimum Multiple Order Quantity";"Minimum Quantity Calculation";Length;Width;Height;Weight;Volume;"Unit Amount";Unit;"Points Needed";"Points Received";"Point Groups";Published;Language;Date;Tags;"Meta Keywords";"Meta Description"

Jan

I know this, but for good import, just a few of these columns
Because iam generate xlsx file via openpyxl and all colums it big data.
I managed to fill only a few columns and it worked
I do not know what?

[Jan]

Hi, sorry I don't understand what you mean with this question: "I do not know what?"

Jan

[mokro]

Which columns can be empty?

[Jan]

Hi, when you save the product in administration, you can get warning message when nothing is filled in (so you can see which columns are required)

Jan

[mokro]

Ooo.. iam solve, this columns can be non empty, and import success.

'title'
'price'
'groups' = """[{"id":"1","title":"COM_PHOCACART_DEFAULT"}]"""
'categories'
'access' = 1
'published' = 1

Its not hack.
thnks, for phoca solutions!
I will definitely prepare a donate

[Jan]

Ok