Quote Originally Posted by pdevo View Post
Hello,

I am new to the ZC Forum and have never posted before. Hoping this is the correct place and method.

Using EP4 and ZC 1.5.1. I loaded 1700 products simultaneously with success, (updated existing and added new), except for the length of the "v_products_name_1" field was too short for some of the products names. The field length is set at 128 according to the "warning" I received on the products "with issues" and the settings shown on the upper right hand part of the EP4 page. I need about 135 in length.

I have looked everywhere for a solution on the Forum. Closest suggestion found in the Forum was to go to phpMyAdmin in cPanel, then go to "products_description" and "change products_name" there to length of 135. Also go to orders_products and change products_names to 135. I did both and it made no difference. I don't see a name for "products_name_v1" - only for "products_name".

Can you please tell me exactly where to adjust this setting? I am not a developer and am without anyone right now to help me but can follow explicit instructions. I hope you can help me.

Thank you.
You came to the right area for this question (I think), good first post, keep up that type of description in future posts.

Either I or someone that already know the answer for the first part will get back to you with how to change the size/length of the field, but there is a part of your post that I don't fully understand, but may make an assumption.

When you say there is no product_name_v1, do you mean that when you look in mysqladmin at the table in question, all you see is product_name and you don't see product_name_1?

The extra _1 is a language "switch". The value of _1 means to assign the product_name to language1 (whatever thatmay be ie. English) a product_2 would be to assign the text to the second language. This way an update can be made to a product in multiple languages. If that has given you enough to make the desired change(s), then good.

Now as for the fulllength needed, should be able to use the spreadsheet program to identify the maximum length of your current products. Add a new column that calculates the length of the cell that has the name, then using a different cell, find the maximum in that column. After you have figured that out, if the new data is on the same spreadsheet as all of your other data, I recommend deleting it before saving/exporting to prepare for upload to urstore. Otherwise do the calculations on a different sheet, and don't have to worry about deleting it. Probably want to add a few characters to the total length so that don't have to increase again any time soon.

Didn't check the above, but hopefully my spacebar worked enough times to not be confusing. :) (cell phone used to type this.)