M
-----------------------------------------------------------------------
My last mods: Partita IVA e CF | Pro EU VAT Number | Sales Agents | Pricelist Pro
-----------------------------------------------------------------------
From being a noob, I'm learning something new each time.
I have to forgo using Customer Group name mod to avoid the 1st error then.
Can I confirm if the discounted price is suppose to replace on original price?
I only made discounts settings through admin> customer group ? I'm hoping it can show both discounted and original price with the Original Price striked through (Just like how default OC cart did it)
Anyway I can do it that way?
Installed the VQMOD version, everything looks installed ok, but the front end all i get is a white page, website itself is not visible, but admin is ok
cannot redeclare customer() or something like that, so had to remove the mod. There are alot of updates to the system files with this, is there any chance of a completely manual update to existing files, so I can add the relevant codes myself.
Code: Select all
Array
(
[customer_group_id] => 1
[approval] => 0
[company_id_display] => 1
[company_id_required] => 0
[tax_id_display] => 0
[tax_id_required] => 1
[sort_order] => 1
[discount] =>
[name] => Default
)
And, if im going to Sale -> Customers -> Customer groups, i get the following error.
Code: Select all
Notice: Error: Unknown column 'name' in 'order clause'
Error No: 1054
SELECT * FROM x_customer_group ORDER BY name ASC LIMIT 0,20 in /x/x/x/x/x/system/database/mysql.php on line 49
Any clue why this happens, @AvanOsch ?ShopOholic wrote:I've installed the extension as described in the file. But when i go to Catalog -> Category and choose the Discount tab, the following shows up.Is this right?Code: Select all
Array ( [customer_group_id] => 1 [approval] => 0 [company_id_display] => 1 [company_id_required] => 0 [tax_id_display] => 0 [tax_id_required] => 1 [sort_order] => 1 [discount] => [name] => Default )
And, if im going to Sale -> Customers -> Customer groups, i get the following error.
Any solution for this?Code: Select all
Notice: Error: Unknown column 'name' in 'order clause' Error No: 1054 SELECT * FROM x_customer_group ORDER BY name ASC LIMIT 0,20 in /x/x/x/x/x/system/database/mysql.php on line 49
AvanOsch wrote:Sorry, missed your message...ShopOholic wrote: Any clue why this happens, @AvanOsch ?
1) What OpenCart version?
2) Using vQMod?
3) Other Extensions?
1. OC 1.5.3.1
2. Using vQMod
3. Using some others.
And the shop language is in norwegian.
You know I think your extension is really good and almost perfect... I think just one thing is missing currently: the possibility to manage/set behavior in case of category conflict when a product is present in more than one category.
IMHO, ideally I imagine the possibility to set it in admin setting with some options like: minimum discount, maximum discount, discount of lower hierarchical level in case of parent categories.
In particular this last option could be important for me and maybe for other ones. In fact some stores are set in the following way: a product is assigned to a categories and all it's parent ones. This gives the possibility to browse dynamically the products, refining step by step the search.
If I is not clear I report here an example to better explain.
A store could have a main category LAPTOPS with 2 child categories MAC and WIN. Each Mac product is assign to both LAPTOPS and MAC categories and each Win product to LAPTOPS and PC.
In this way if a customer click to LAPTOPS, he can see all laptops in the store, both Mac and Win. If he then want to refine his search, he can click on Mac and get only Mac products.
Coming back to you magic extension, it fails in these cases because I could decide to apply a 20% discount to all LAPTOPS with the exception of PC where I want to grant a 25% discount. With current behavior the same product shows a different discount with relation to the selected category and this can't be correct.
I hope I clarified my opinion. Do you think something similar is generally possible to integrate in you work?
Regards,
M
-----------------------------------------------------------------------
My last mods: Partita IVA e CF | Pro EU VAT Number | Sales Agents | Pricelist Pro
-----------------------------------------------------------------------
Hi M,madimar wrote: I hope I clarified my opinion. Do you think something similar is generally possible to integrate in you work?
I'm not sure this is possible (I don't think so)
As is stated in the Documentation (Known Catches):
Also, please remember this is a Free extension.Products with multiple Categories assigned (AND different Discounts per category).
In this case the script will get the first found category, not the current category.
Not solved, because when the product is in the cart (for example), we don't know
what category the product originally came from...
It does what I need it to do, and I'm not planning on making any big changes...
If I can find the time, I'll have a look at what can be done (but don't expect too much)
Best regards,
Albert
Said that, I have a perception this improvement is not really impossible: finally the discount is applied to a product. It is "only" necessary to analyze all the product categories and choose the discount to be applied according to desired rules.
I will try to analyze the thing and try to contribute to your work possibly.
Regards,
Max
Sent from my DesireHD.
-----------------------------------------------------------------------
My last mods: Partita IVA e CF | Pro EU VAT Number | Sales Agents | Pricelist Pro
-----------------------------------------------------------------------
Contributions are always welcome, and will be included if they work properly.madimar wrote:I will try to analyze the thing and try to contribute to your work possibly.
If more people would do this (with all extensions), the "Free Extensions Section" of OpenCart would get a lot better...
Notice: Undefined index: name in /vqmod/vqcache/vq2-admin_model_catalog_category.php on line 211
I emptied the vqcache, but keep getting the same error.
Everything seems to work fine, but if I add a discount to a specific customer group it shows the discount pirce also as the price Exc. VAT. in the shop.

I'm running:
Opencart: 1.5.4.1 with the default theme and in language Dutch
vqmod-2.2.0-opencart
Customer Group Discounts v1.0.5
Help is appreciated, thanks for the great mod

TIA
Nienke
Users browsing this forum: No registered users and 6 guests