[RELEASED] - Option Model And Sku

This will be the official support forum topic for this contribution:

http://www.opencart.com/index.php?route ... on_id=5826

Hi straightlight,

My oc version is V 1.5.3.1

I have try to input `model` & `sku` in admin-end > Catalog > options > option name > enter one option >, then I got the following error.

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error No: 1064
INSERT INTO option_value_description SET option_value_id = '64', language_id = '1', option_id = '11', name = 'Big', `model` = 'Big001', `sku` = 'Big001', in C:\xampp\htdocs\r002\system\database\mysql.php on line 49

Could you tell me how to fix it?

Thanks a lot! ^@^

prince727372 - 18/10/2012


Hi straightlight,

My oc version is V 1.5.3.1

I have try to input `model` & `sku` in Catalog - options - option name, then I got the following error.

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error No: 1064
INSERT INTO option_value_description SET option_value_id = '64', language_id = '1', option_id = '11', name = 'Big', `model` = 'Big001', `sku` = 'Big001', in C:\xampp\htdocs\r002\system\database\mysql.php on line 49

Could you tell me how to fix it?

Thanks a lot! ^@^

This error message has nothing to do with my contribution specifically since none of my modifications implies the use of the option_value_description table.

Hi!

First of All, thanks! =D

My problem is this: The form to fill with the SKU information on options doesn't show up.

And when I enter in Options admin this error shows:
Can you help me plz?

This error message may be related with another contribution. If you disable my XML file and re-test the page where you see the error message, does this error message persists ?

--------------------------
-- Documentation --
--------------------------
(because the steps provided thus far a not adequate for the lay-person):
Tested on VQMod 2.2 w/ OpenCart 1.5.4

1) Make sure that VQMod is installed properly:
http://yourdomain.com/vqmod/install/ If it does not say that it is installed, then install it and come back.

2) Upload the contents of the upload folder to your site directory. Just drag and drop into a tool like FileZilla. (by default, it will not overwrite the matching folders, but add the new files to them).

3) Open a MySQL client such as TOAD or PhpMyAdmin. Run the following where my_db is the database that you installed OpenCart into. Note that some people might have opted to add a prefix to the tablenames. I did not, but check to see if you need that. i.e. "my_db.OC_option_value":
ALTER TABLE my_db.option_value ADD model VARCHAR(64) COLLATE utf8_bin NOT NULL;
ALTER TABLE my_db.option_value ADD sku VARCHAR(64) COLLATE utf8_bin NOT NULL;
ALTER TABLE my_db.order_option ADD model VARCHAR(64) COLLATE utf8_bin NOT NULL;
ALTER TABLE my_db.order_option ADD sku VARCHAR(64) COLLATE utf8_bin NOT NULL;

3) Then go back to your file system (FTP, SSH, etc.) and from the main directory go to vqmod/xml/options_model_sku.xml

REPLACE:
<file name="admin/model/catalog/option.php">
<operation>
<search position="after" index="1"><![CDATA[image = '" . $this->db->escape($option_value['image']) . "',]]></search>
<add><![CDATA[
`model` = '" . $this->db->escape($option_value['model']) . "', `sku` = '" . $this->db->escape($option_value['sku']) . "',
]]>
</add>
</operation>

WITH:
<operation>
<search position="before" index="1"><![CDATA[[sort_order]]]></search>
<add><![CDATA[
<td class="left"><input type="text" name="option_value[<?php echo $option_value_row; ?>][model]" value="<?php echo (!empty($option_value['model'])) ? $option_value['model'] : ''; ?>"></td>
<td class="left"><input type="text" name="option_value[<?php echo $option_value_row; ?>][sku]" value="<?php echo (!empty($option_value['sku'])) ? $option_value['sku'] : ''; ?>"></td>
]]>
</add>
</operation>

REPLACE:
<operation>
<search position="before" index="2"><![CDATA[[sort_order]]]></search>
<add><![CDATA[
html += '<td class="left"><input type="text" name="option_value[<?php echo $option_value_row; ?>][model]"></td>';
html += '<td class="left"><input type="text" name="option_value[<?php echo $option_value_row; ?>][sku]"></td>';
]]>
</add>
</operation>

WITH:
<operation>
<search position="before" index="2"><![CDATA[[sort_order]]]></search>
<add><![CDATA[
html += '<td class="left"><input type="text" name="option_value[<?php echo $option_value_row; ?>][model]"></td>';
html += '<td class="left"><input type="text" name="option_value[<?php echo $option_value_row; ?>][sku]"></td>';
]]>
</add>
</operation>

4) Logout of OpenCart. Clear cache in your browser. Log back in. Go to Catalog>Options. Insert and option and you will see Model and SKU columns. Now you can have true configurable products.

Note: I have not tested how this looks in the invoices yet.

Hope this helps!

i have followed the above instruction (bar the first replacement of code i belive you missed off: <file name="admin/model/catalog/option.php">)

yet i cannot see anything in the options. im running 1.5.4.1 please can you advise?

I have also followed the above instructions and am having the same problem. The sku column does not show up

I am using Mijoshop ver. 1.4.5
Open Cart version 1.5.5.1
VQmod manager ver. 2.0-beta.6

This is a typical error log entry

REQUEST URI : /administrator/index.php?option=com_mijoshop&route=catalog/product/update&token=d7c3541f979a3604e77a7c119af86c9d&product_id=35
MOD DETAILS:
modFile : /home/mysite/public_html/components/com_mijoshop/opencart/vqmod/xml/options_model_sku.xml
id : Options Model / SKU
version : 1.0
vqmver : 2.1.5
author : Straightlight
SEARCH NOT FOUND (ABORTING MOD): [sort_order]

This looks like the extension I am looking for but I need to clarify what it does. I need a sku assigned to each option variable for example,
Option
size sku
0-3 mos 03bn09876
6-12 mos 62bn87620
2T s2bn76398
3T 3tbn54309

This contribution only allows to add extra option model and sku by individual values, not by grouped values.

I am wanting to use this extension to create unique skus at the option level in hopes quickbooks pos and webgility will sync inventory at this variant level. I am told by a very nice webgility rep (their customer service is unbelievable) that it will not work because-

"The reason why the Open Cart extension doesn't work is because the relationships are not really being segmented from a "coding" perspective. Although what you see is a unique variant sku created from a product option, that new sku is still tied to the "parent" item.

eCC must see the relationship actually separted from the parent and child items in order for it to truly work like what we discussed"

Can you verify this and is there anything you can do if this is true to help make this work.
Thank you in advance.

None of my description on the OC market describes anything about QuickBooks POS and Webgility. What you're referring and hoping to have is an API module that can be developed between OC and QuickBooks POS which my contribution has nothing to do with what you're requesting above nor was it discussed anywhere previously on the topic.

Thank you for getting back to me Straightlight. Let me rephrase my question. Does your extenstion create sku's that are attached to the parent item ? If it is, would you like to consider revising it for a fee so it disassociates itself from the parent item to work with QB POS and Webgility? Or would that cause other problems. I don't know these things and why I ask. I am trying to learn. Just because your extension wasn't written specifically for what I am wanting to use it for does not necessarily mean it couldn't be used. Not all extensions written are perfect for all needs. I'm a very creative person and I am diligently trying to find a solution for my client. I just thought your extension could help.

Just because your extension wasn't written specifically for what I am wanting to use it for does not necessarily mean it couldn't be used. Not all extensions written are perfect for all needs.

Couldn't agree more. Send me a PM for further customization in order to match your requirements with QB POS and Webgility.

Hi Straightlight,

Can you tell me if this is how your ext works?

I have a product model# "ZZZZZ"
I have an option with model# "111"

If my customer selects product "ZZZZZ" with option "111" will the final model# be "ZZZZZ111" or just "111". I need it to produce the first one.

Thanks

It produces the options you're assigning to the product options by also displaying the option model and option sku period.

Hi there,

Just uploaded your component on my OpenCart 1.5.5.1. Nothing showed up in the options. Did I miss something during the install?

Thanks.

Bump. Please give me any hint to make this extension work as I didn't get any answer and I paid for it. So far nothing showed up in my options. Thanks.

Would it be possible to elaborate: Nothing showed up ?

- What are the steps that you did?
- Did you installed other contributions which XML files may target the same OC files?
- Has it ever worked before?

Without details, I cannot assist period.