Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Introducing Cs-Cart 4.6.1 With Product Variations Rate Topic   * * * * * 1 votes

 
  • ikoshkin
  • Tech Writer
  • CS-Cart Architects
  • Join Date: 25-Nov 15
  • 126 posts

Posted 26 January 2018 - 01:16 PM #101

QUICKBOOKS IMPORT ISSUE: ...


Hello, Matthew. I see that you have already posted this issue on our bug tracker. Thank you, our specialists will reply to you there.

 
  • ikoshkin
  • Tech Writer
  • CS-Cart Architects
  • Join Date: 25-Nov 15
  • 126 posts

Posted 26 January 2018 - 01:53 PM #102

...
The Options column is the most laborious to create by hand.
...
I want to propose another solution to create configurable products from previously imported product variations. To see if it would be possible.
 
1.- Import Product variations as variable products (marked as V in column Type)
2.- Select products imported in Backend=>Manage products
3.- Click on new option named "Create configurable product based on products selected"
4.- The previous button opens a popup or page with a form in which the necessary data (name, options, variants,...) are requested to create the configurable product linked to the products previously selected.
 
I do not know if this would be very complicated to do but it would make the job much easier for the store administrators, since each provider offers the data in a different way.
 
Thank you
 
Josep


Thank you for your feedback and suggestions, as well as the scenario that you provided in a private message. We are looking for ways to improve product import. But before we can say if the offered solution is feasible, we'd like to get an example of the file that your suppliers send to you. We did see an example extract in the private message you sent, but we'll need an actual file, with data split into columns, as you receive it from your supplier.

For example in this extract:

123456 Helmet blue size M
123457 Helmet blue size L
123458 Helmet blue size XL
123459 Helmet red size M

I can't see the titles of the columns, nor can I say if the columns are split as "123456 | Helmet blue size M" or "123456 | Helmet | blue | size M". This difference could mean a lot, as it's important to figure out how CS-Cart will determine that "this variation is a combination of Option A variant 1 and option B variant 2".

Besides, manually grouping variations into configurable products after import is still additional manual work imposed on administrators. If you could send us an actual file from your supplier as an example, we might figure out a way how to automate this process.

 
  • Josep
  • Junior Member
  • Members
  • Join Date: 12-Jan 07
  • 21 posts

Posted 26 January 2018 - 04:26 PM #103


For example in this extract:
I can't see the titles of the columns, nor can I say if the columns are split as "123456 | Helmet blue size M" or "123456 | Helmet | blue | size M". This difference could mean a lot, as it's important to figure out how CS-Cart will determine that "this variation is a combination of Option A variant 1 and option B variant 2".

Besides, manually grouping variations into configurable products after import is still additional manual work imposed on administrators. If you could send us an actual file from your supplier as an example, we might figure out a way how to automate this process.

 

Thank you ikoshkin,

 

The most common file that suppliers provide me has the options integrated within the title, for example:
 
SKU; Product_Name; Price; ...
123456; Helmet blue M; 150.25; ...
123457; Helmet blue L; 150.25; ...
123458; Helmet blue XL; 150.25; ...
But it is not a problem for me to separate the options in columns, it is relatively easy and fast in a spreadsheet.
 
The problem is when in a list of hundreds (or thousands) of products you have to separate the data into groups of X rows (for example, same product of different sizes) to create a new row in each group with the configurable product and above all with the list of options within the same field (options).
Creating this line, which you can see example below, is a manual work that is slower than making the product configurable in Cs-cart admin and is the real bottleneck to import configurable products (I think).
|options|
(Simtech) Color: S[White,Black,Blue,Red,Green,Yellow]///inventory=Y///missing_variants_handling=M///multiupload=N///required=N///status=A; (Simtech) Size: S[Small,Medium,Large,X Large,XX Large]///inventory=Y///missing_variants_handling=M///multiupload=N///required=N///status=A

Thank you very much for your interest in improving this important aspect.


Cs-cart 4.7.1