- Posts: 2
- Thank you received: 0
[CSV Adv] Scheme for the CSV for multiple attr/opt
- sys3acc
- Topic Author
- Offline
- New Member
Less
More
9 years 5 months ago - 9 years 5 months ago #65542
by sys3acc
[CSV Adv] Scheme for the CSV for multiple attr/opt was created by sys3acc
Hello,
there wasn't enough characters to write the subject out fully.
I need to know how the scheme of the CSV that is to be imported is supposed to be when I want my products to have multiple attributes and options.
Right now if I have multiple columns of, say, 'option_name', only the last one is applied.
And with attributes I have no clue how to form a connection between 'attribute', 'attributegroup', 'product' and 'attribute_value'.
I tried creating the attributegroups and attributes first and this was successful, meaning the attributes were created and they had a connection with the created attributegroups.
But with the second import where I tried to set 'attribute_name' to one of the attributes and 'attribute_value' to the value for this product, the resulting product had no attributes when looking at it from the admin panel.
How do I need to write my CSV to accommodate my needs of multiple attributes and multiple options for one product?
Thank you.
there wasn't enough characters to write the subject out fully.
I need to know how the scheme of the CSV that is to be imported is supposed to be when I want my products to have multiple attributes and options.
Right now if I have multiple columns of, say, 'option_name', only the last one is applied.
And with attributes I have no clue how to form a connection between 'attribute', 'attributegroup', 'product' and 'attribute_value'.
I tried creating the attributegroups and attributes first and this was successful, meaning the attributes were created and they had a connection with the created attributegroups.
But with the second import where I tried to set 'attribute_name' to one of the attributes and 'attribute_value' to the value for this product, the resulting product had no attributes when looking at it from the admin panel.
How do I need to write my CSV to accommodate my needs of multiple attributes and multiple options for one product?
Thank you.
Last edit: 9 years 5 months ago by sys3acc.
Please Log in or Create an account to join the conversation.
- Giang Dinh Truong
- Offline
- Administrator
9 years 5 months ago #65598
by Giang Dinh Truong
Replied by Giang Dinh Truong on topic [CSV Adv] Scheme for the CSV for multiple attr/opt
Hello,
You should use field separator to specify multiple options and attributes. Example:
option_name: Size;Size;Color;Color;Color
option_value: Small;Medium;Red;Blue;Green
option_price: 1.5;2;3.0;3.5;5.0
with ; is field separator. Same for attributes and attribute groups.
Hope that this will help.
Sincerely, Giang
You should use field separator to specify multiple options and attributes. Example:
option_name: Size;Size;Color;Color;Color
option_value: Small;Medium;Red;Blue;Green
option_price: 1.5;2;3.0;3.5;5.0
with ; is field separator. Same for attributes and attribute groups.
Hope that this will help.
Sincerely, Giang
Please Log in or Create an account to join the conversation.
- Giang Dinh Truong
- Offline
- Administrator
8 years 7 months ago #81372
by Giang Dinh Truong
Replied by Giang Dinh Truong on topic [CSV Adv] Scheme for the CSV for multiple attr/opt
Hello,
Today, we release EShop Import Pro to replace EShop CSV Advanced. You can import data from Excel easily with EShop Import Pro now. Please read more about it in the topic: joomdonation.com/forum/add-ons-payment-s...op-csv-advanced.html
Full of documentation is available here now: eshopdocs.joomservices.com/eshop-import-pro
Sincerely, Giang
Today, we release EShop Import Pro to replace EShop CSV Advanced. You can import data from Excel easily with EShop Import Pro now. Please read more about it in the topic: joomdonation.com/forum/add-ons-payment-s...op-csv-advanced.html
Full of documentation is available here now: eshopdocs.joomservices.com/eshop-import-pro
Sincerely, Giang
Please Log in or Create an account to join the conversation.
Moderators: Giang Dinh Truong
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.