Categories
View Replies (6)

Resolved question about 500 internal error, custom_title, product_parent & custom_value

  1. marios_Sot
    marios_Sot
  2. RO CSVI
  3. Monday, 11 September 2017
  4.  Subscribe via email
Hello,
I fixed the problem I had with the 0' for key 'PRIMARY', cleaned my csv file and template fields and my test import works out fine. Since the test imported my files ok, I proceeded to upload my csv file which had over 5000 items and the 500 Internal Server error came up, so I made two csv files 2500 each and uploaded one the error came up, I uploaded the second and the error came up again. I contacted the person that created my website a couple hours later and he informed me that there are too many items uploaded and that is probably why, but when he went to check virtueMart there were 800 products imported. By the next day in the morning there were over 2700 products imported. Do you know why this happened and even though the error showed, most products on the csv where imported?

My next question is about the custom_title and custom_value. In my products, for example, I have the following that need to be imported: condition (e.g new, old, used), color (e.g blue, red, etc), size (e.g L, XL, 36, 40 etc) , material (e.g wood, fabric, metal etc). I haven't found any fields for these and I was wondering if I can use custom_title and custom_value for these but how will they be recognized in the products that custom_title is for condition or color? Do I have to create another template or for these to be recognized in Virtuemart products?

My final question is about product_parent_sku and product_sku. This works ok and it shows in virtuemart products that for example
product_parent_sku LACE has (2) children
product_sku LACE-RED is children of LACE
product_sku LACE-BLACK is children of LACE
in my website though, each item is shown as an individual product so I end up having eg. 3 individual products: LACE, LACE-RED and LACE-BLACK rather than one product "LACE" with different variables to chose from (choose red or black) which is how I want it to come up.How can I make the child products show in the same parent product?

I'm using VirtueMart 3.2.1. and Joomla! 3.7.4

Thank you for your help!
0
Responses (6)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I fixed the problem I had with the 0' for key 'PRIMARY', cleaned my csv file and template fields and my test import works out fine. Since the test imported my files ok, I proceeded to upload my csv file which had over 5000 items and the 500 Internal Server error came up, so I made two csv files 2500 each and uploaded one the error came up, I uploaded the second and the error came up again. I contacted the person that created my website a couple hours later and he informed me that there are too many items uploaded and that is probably why, but when he went to check virtueMart there were 800 products imported. By the next day in the morning there were over 2700 products imported. Do you know why this happened and even though the error showed, most products on the csv where imported?

Your server might hit its limits when you are importing the products which would be the cause for 500 error. The products you are seeing would have been imported till the limit has been hit. Have a look at Manage timeouts document to know on how to limit the product import.

My next question is about the custom_title and custom_value. In my products, for example, I have the following that need to be imported: condition (e.g new, old, used), color (e.g blue, red, etc), size (e.g L, XL, 36, 40 etc) , material (e.g wood, fabric, metal etc). I haven't found any fields for these and I was wondering if I can use custom_title and custom_value for these but how will they be recognized in the products that custom_title is for condition or color? Do I have to create another template or for these to be recognized in Virtuemart products?

No you don't need another template. Have a look at Product import with custom fields to know on how to use custom_title and custom_value fields.

My final question is about product_parent_sku and product_sku. This works ok and it shows in virtuemart products that for example
product_parent_sku LACE has (2) children
product_sku LACE-RED is children of LACE
product_sku LACE-BLACK is children of LACE
in my website though, each item is shown as an individual product so I end up having eg. 3 individual products: LACE, LACE-RED and LACE-BLACK rather than one product "LACE" with different variables to chose from (choose red or black) which is how I want it to come up.How can I make the child products show in the same parent product?

You need to add your child product as variants so they are available in parent product. You can use the VirtueMart built in custom field type Multi Variants to do that. Have a look at import Multi variant custom field document to know on importing Multi variants using CSVI.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
marios_Sot
marios_Sot
Accepted Answer Pending Moderation
Hello tharuna,
Thank you for your reply. I tried the multi variants but still the products do not show as one product. I created a new template and I used the following template fields on csvi pro and my csv file:

product_parent_sku, product_name, product_desc, product_price, category_path, file_url, condition, color, size, material, product_sku, published, intnotes, low_stock_notification, multi_variant_title, multi_variant_fields

The child products still show up as separate from the parent product, is there something else I need to do on the template? I have also created the multi variant field in Virtuemart custom fields.

Thank you
Marios
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marios,
Can you post the debug log of the import? To know on how to get the debug log, check Where to get the debug information? on top of this page. Also post sample import file along with debug log.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
marios_Sot
marios_Sot
Accepted Answer Pending Moderation
Hello tharuna,

I did another test again now, I don't know what I am doing wrong. I've really been struggling for two weeks with uploading my files and having them show up correctly.. I have uploaded the debug log and the a sample import file for you to check

Thank you
Marios
Attachments (2)
com_csvi.log.32 (1).zip
test for multi-variants.png test for multi-variants.png
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Marios,

I've really been struggling for two weeks with uploading my files and having them show up correctly..
You have the basics working right?

If you have trouble making the CSV file you want to import, you can also create 1 product by hand as to how you want it to look like. Export this product using CSVI and check how the fields are filled. That should give you a good starting point to fill in the rest. Did you read the documentation of the Multi Variants that Tharuna gave you? You will see that your CSV file looks quite different.

Looking at your CSV file I see a number of inconsistencies:
  1. The product_parent_sku has the wrong values. This is the SKU of the parent product. This field must be empty for the parent product.
  2. Post a screenshot of the multi variant field you created so we can see how you set it up, is it called Multi Variant?

After you fixed the CSV file, make sure you import the file twice as stated in the documentation.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
marios_Sot
marios_Sot
Accepted Answer Pending Moderation
Hi Rolandd,

Yes the basics work fine, CSVI is perfect for what I need but it took some time for me personally to figure things out. I checked my csv file and it was very badly put together from my manufacturer, so I fixed all that and I removed the product_parent_sku from the parent product and added the Multi Variant and it works like a charm! Everything is where it's supposed to be

Thank you and tharuna for all the help!
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!