Categories
View Replies (8)

Resolved Import related products

  1. lightco
    lightco
  2. RO CSVI
  3. Wednesday, 17 February 2016
  4.  Subscribe via email
Hello,

I have been trying to import related products for a while but it never worked.
Template import:
First attempt

Action: Import
Component: Virtuemart
Operation: Related products
Fields:
1 product_sku
2 related_sku
My csv:
1 product_sku
2 related_sku separated by |
Attached the log1

Second attempt:
Action: Import
Component: Virtuemart
Operation: Products
Fields:
1 product_sku
2 related_products
Same csv
I attached the log file as well and
I have this error message.
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT `p1`.`virtuemart_product_id` AS `virtuemart_product_id`,`p2`.`virtuemart_product_id` AS `customfield_value` FROM `d7bxh_csvi_related_products` AS `r` LEFT JOIN `d7bxh_virtuemart_products` AS `p1` ON `r`.`product_sku` = `p1`.`product_sku` LEFT JOIN `d7bxh_virtuemart_products` AS `p2` ON `r`.`related_sku` = `p2`.`product_sku`

Can you please please help?
0
Responses (8)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
First attempt

Action: Import
Component: Virtuemart
Operation: Related products
Fields:
1 product_sku
2 related_sku
My csv:
1 product_sku
2 related_sku separated by |
Attached the log1

This is the correct way of doing the import but your log file is missing to check on the issue. Also attach the file you used for import so i can test it.

Regarding the SQL error, you can ask your hosting provider. They will be able to modify the database configuration file to fix this.
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
lightco
lightco
Accepted Answer Pending Moderation
its the same file.
I attach it here again.

What exactly should I say to my host provider?
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your log file is still missing in the message. If the file is too big please compress and post it.

MYSQL determines whether or not a query is large based on the value of MAX_JOIN_SIZE variable. Since your query is returning more than this number of rows, you are seeing the error. To solve this you can ask your hosting provider to turn on SQL_BIG_SELECTS variable if it is off in mysql configuration file.
Also, one more way to prevent this error is by adding indexes to your table.
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
lightco
lightco
Accepted Answer Pending Moderation
log
Attachments (1)
com_csvi.log.145.txt.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
lightco
lightco
Accepted Answer Pending Moderation
None of the related product are uploaded.
I have tried a million time.
:angry: :(
  1. more than a month ago
  2. RO CSVI
  3. # 5
lightco
lightco
Accepted Answer Pending Moderation
csv
Attachments (1)
SkuandRelatedproductsonly.zip
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you PM us your site login details and db access? I will have a look at the site and check the issue, related products functionality in general is working.
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. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Please also include FTP login details so we can check what is happening with your import.
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. # 8
  • Page :
  • 1


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