Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy CVS problem: no name & description


JLT80

Recommended Posts

Dear...

 

I have installed the contribute "Easy CVS". Everything is working fine except for the name & description elements. I am using the dutch language but also in English there is no name of description is showing up.

 

I have tried to adjust the ini files and the PHP file but nothing worked. Maybe some of you have any sugestions or iedeas?

 

I love this contribute because it's nice and simple and hopefully it going to work proparly.

 

With regards,

Jelte V.

The Netherlands

 

Ps. Below you will find the .ini files and the example .CSV file I use

 

 

-------------------------------------- CSV_import.ini --------------------------------------

 

[settings]

 

debug = "0"

csv_upload_folder = "csv"

correct_fields_count = "1"

correct_fields_radius = "5"

products_default_status = "0"

default_category_id = "0"

auto_add_categories = "1"

import_images_urls = "1"

image_name_delimiter = "|"

allow_empty_db = "1"

decimal_point = "."

thousands_sep = ","

 

[csv]

 

delimiter = ";"

enclosure = ""

columns_headers = "category, model, name_en, name_es, name_it, name_de, name_nl, name_fr, quantity, image, price, weight, description_en, description_es, description_it, description_de, description_nl, description_fr, tax class, manufacturer name"

columns_headers_delimiter = ","

categories_delimiter = "|"

categories_subcat_delimiter = "."

categories_language = ""

 

[products]

 

products_model = "1"

products_image = "9"

products_price = "10"

products_quantity = "8"

products_weight = "11"

products_tax_class_id = "18"

 

[categories]

 

categories_id = "0"

 

[manufacturers]

 

manufacturers_id = "19"

 

[products_description]

 

products_name = "en:2, es:3, it:4, de:5, nl:6, fr:7"

products_description = "en:12, es:13, it:14, de:15, nl:16, fr:17"

 

 

 

-------------------------------------- example.csv --------------------------------------

 

Category;Model;Name_en;Name_es;Name_it;Name_de;Name_nl;Name_fr;Quantity;Image;Pr

ice;Weight;Description_en;Description_es;Description_it;Description_de;Descriptio

n_nl;Description_fr;Tax Class;Manufacturer

test33;KING1G533;;;;;1GB Ram Memory;;50;memoria.jpg;50,99;0,2;;;;;memoria ram da 1gb;;BTW;

Link to comment
Share on other sites

Are you sure your oscommerce language code is "nl"? I remember a similar case like yours where the language code was "ho" not "nl".

 

Check it in admin->localization->languages

 

tip: you can remove unused languages from cvs and csv_import.ini (don't forget columns_headers setting)

 

 

Let me know.

Link to comment
Share on other sites

Thanks for your reply!

 

The languages code in my shop is "NL" not "nl" does this make any difference? If so how do I change this in Easy CVS. I know I can remove te other languages but I first want to get the script working before I make any other changes. One thing at a time ;-)

 

Thanks!

Jelte

 

 

 

 

Are you sure your oscommerce language code is "nl"? I remember a similar case like yours where the language code was "ho" not "nl".

 

Check it in admin->localization->languages

 

tip: you can remove unused languages from cvs and csv_import.ini (don't forget columns_headers setting)

 

 

Let me know.

Link to comment
Share on other sites

Languages are updates. It's working like a charm!

 

But I have an extra field called (Extra). I have the "csv_import.ini" updated (see below) I also have an extra field in the CVS file called Extra on place 20

 

Could you please help me out here?

 

Grtz

Jelte

 

 

------------------------------------ csv_import.ini ---------------------------------------

 

[settings]

 

debug = "0"

csv_upload_folder = "csv"

correct_fields_count = "1"

correct_fields_radius = "10"

products_default_status = "0"

default_category_id = "0"

auto_add_categories = "1"

import_images_urls = "1"

image_name_delimiter = "|"

allow_empty_db = "1"

decimal_point = "."

thousands_sep = ","

 

[csv]

 

delimiter = ";"

enclosure = ""

columns_headers = "category, model, name_nl, quantity, image, price, weight, description_nl, tax class, manufacturer name, Extra"

columns_headers_delimiter = ","

categories_delimiter = "|"

categories_subcat_delimiter = "."

categories_language = ""

 

[products]

 

products_model = "1"

products_image = "9"

products_price = "10"

products_quantity = "8"

products_weight = "11"

products_tax_class_id = "18"

 

[categories]

 

categories_id = "0"

 

[manufacturers]

 

manufacturers_id = "19"

 

[extra velden]

 

Extra = "20"

 

[products_description]

 

products_name = "NL:6"

products_description = "NL:16"

 

------------------------------------ end csv_import.ini ---------------------------------------

Link to comment
Share on other sites

if your field goes into products table just add it in [products] section inside ini file.

 

[products]

 

products_model = "1"

products_image = "9"

products_price = "10"

products_quantity = "8"

products_weight = "11"

products_tax_class_id = "18"

extra = "20"

Link to comment
Share on other sites

  • 5 months later...

Hello,

 

first, thanks for this contrib. Works really good for my needs.

 

One thing I woult like to implement, but dont´t know how to solve.

 

Is it possible to make a minimum price, for example all products in the csv which are 50€ ore more expensive will be imported, all other will be ignored?

 

Any hint ist greatly appreciated ;)

 

Thanks

Link to comment
Share on other sites

  • 6 years later...

Yes, it's different.

You must change "nl" to "NL" in your csv_import.ini, under [products_description] section

HI! I have troubl with import product with russian languages. Text abcent in my russian product, then i import.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...