product combinations generator with unique reference

[zeki893]

Hi anybody know how to modify the combinations generator so that we can get unique reference codes? Currently it uses the same code for all new combinations. Would like to add the color and size attribute to it for example <reference>-<color>-<size>

Any help is appreciated 

[wgeppert]

Hi, I developed a product builder what would do the Job. Please see attached Screen shot.

 

[zeki893]

Hi, I developed a product builder what would do the Job. Please see attached Screen shot.

where can i find this? where does it generate a unique reference code?

Does anybody else run into this problem? I'm using the amazon module and updating reference code for every size and color combination is taking up a lot of time.

[wgeppert]

Hi zeki893,

You can tell exactly what you want to do and I will provide you this app as testversion for your use only. The requirements are Windows, .NET 4.0, MySQL installed. I would upload a zip in the cloud.

[zeki893]

Hi zeki893,

You can tell exactly what you want to do and I will provide you this app as testversion for your use only. The requirements are Windows, .NET 4.0, MySQL installed. I would upload a zip in the cloud.

hm... i was looking for something in the back office. i guess i can try it out. i want to generate combinations with unique reference.

Edited January 7, 2015 by zeki893 (see edit history)

[zeki893]

Okay so I'm gonna try to figure this out myself.

 

I found in AdminAttributeGeneratorController.php is where I can modify the reference.

'reference' => pSQL($_POST['reference']),

 

So I got the product attribute id, but how can i convert from id to name from attribute_lang.id_attribute to attribute_lang.name

so i can add to the reference the color name?

Edited March 2, 2015 by zeki893 (see edit history)

[zeki893]

Actually hacked a way to get this working. 

So if anybody needs help with creating unique product reference IDs this will save you tons of time especially for posting combination products with 8 different colors.

Super useful for posting on Amazon using the Amazon module since amazon requires unique reference ID.

http://itheadaches.com/prestashop-create-unique-reference-id-product-combinations-generator/

[sunshinevapedotcom]

what version prestashop is this running on ? 

[nathanielleee]

Actually hacked a way to get this working. 

So if anybody needs help with creating unique product reference IDs this will save you tons of time especially for posting combination products with 8 different colors.

Super useful for posting on Amazon using the Amazon module since amazon requires unique reference ID.

http://itheadaches.com/prestashop-create-unique-reference-id-product-combinations-generator/

 

 

I implemented this but still no reference is made when i update the combinations

[kiseed]

After struggling with the problem, finally I found the error on zeki893's solution.

 

Apparently he didn't use the usual table prefix ps_ so just replacing:

$sqltest = 'SELECT * FROM `attribute_lang` WHERE `id_attribute` = '. $attribute .' LIMIT 0 , 1';

for:

$sqltest = 'SELECT * FROM `ps_attribute_lang` WHERE `id_attribute` = '. $attribute .' LIMIT 0 , 1';

worked for me