NSPGK5 and VM2

The module doesn't show any products! Why? If I active the debug mode it give me an SQL error:

JDatabaseMySQLi::query: 1064 - 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 ') AND category.published = '1' ORDER BY content.virtuemart_product_id ' at line 20 SQL=SELECT DISTINCT content.virtuemart_product_id AS id, cat.virtuemart_category_id AS cid, cat.category_name AS cat_name FROM q32xf_virtuemart_products AS content LEFT JOIN q32xf_virtuemart_product_categories AS category_xref ON category_xref.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN q32xf_virtuemart_categories AS category ON category_xref.virtuemart_category_id = category.virtuemart_category_id LEFT JOIN q32xf_virtuemart_categories_it_it AS cat ON category_xref.virtuemart_category_id = cat.virtuemart_category_id WHERE () AND category.published = '1' ORDER BY content.virtuemart_product_id ASC

I have another problem with Cart Popup. The popup work but it is empty!

Here the website: www.indde.it/decosud

In the query the WHERE condition is empty!

Hi

Module is still in delelopment mode and presented only for testing purposes. Please update it with the latest version available. I know that some fixes has been already released.

It's already the last version! The v.1.1 in the demo package works fine but the last version (1.1.1) doesn't work. I don't find the old version anywhere!

About the cart problem?

Hi

Please send me an access to joomla panel. I'll check both issues.

I have some issues too with the popup cart and prices not showing. Disabling 'Enable shoppergroup specific price display' in Virtuemart shopper groups makes the prices show again.

Hi

Yes VM got many options for that. But there is no option to add a group for regular guests. So no way to set anything for group which doesn't exists I hope this would be fixed soon. I had so many problems because of that too.

The problem isn't the group! My WHERE condition is empty!

It's absurd! Now when I click on "Add to cart" module the Virtuemart Popup doesn't appear!!!
This template have only problem! The News Show Pro Module doesn't work, the Cart popup doesn't work and the Virtuemart Popup doesn't work!!!! It's totally different by the demo!!
I have installed the Quick Package also... NSPGK5 works but if I install the Italian Language site it doesn't work!!! Please solve this issues or contact me on my personal email for help!

I got StoreBox template with VirtueMart instaled and configured in QuickStart.
When i instaled this Template the News Show ProGK5 module showed the prices of Virtue Mart Products without problems, but when i changed VirtueMart Language from en-GB to pt-BR, the prices disappeared.

If i select Portal Mode option the prices is OK, but i miss all main template visual effects. (prices in color balloons).

We have any update or fix to solution?

* My Site: http://www.eternizejoias.com.br/site/

Hi

Yes that was my second guess. VM got an unique structure for multilanguage content, but there is a way to workaround that. Please create a module for each language You have, than attach every module to this specific language. Next step is to configure module while browsing throught joomla panel while the language in a language You would like to configure it for.

@indde please check if the above is not a case in Your situation. Groups settings can produce an empty WHERE if there were no products for the group You are viewing the site with. Have You installed any additional extentions ? I have made 3 sites already using this quickstart and there were not even one problem.

I am having the same issue. I was told to private message konrad days ago and no one is responding or helping. I have tried everything! This seems to be a common issue.

www.thriftoutfitters.com

Hi

Looks like it is, so if none of my ideas what can cause is giving results I'll send it to programmers. GK5 is still in development mode release for testing purposes, so please use GK4 instead till the fix for this will be available.

The module doesn't show any products! Why? If I active the debug mode it give me an SQL error:

JDatabaseMySQLi::query: 1064 - 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 ') AND category.published = '1' ORDER BY content.virtuemart_product_id ' at line 20 SQL=SELECT DISTINCT content.virtuemart_product_id AS id, cat.virtuemart_category_id AS cid, cat.category_name AS cat_name FROM q32xf_virtuemart_products AS content LEFT JOIN q32xf_virtuemart_product_categories AS category_xref ON category_xref.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN q32xf_virtuemart_categories AS category ON category_xref.virtuemart_category_id = category.virtuemart_category_id LEFT JOIN q32xf_virtuemart_categories_it_it AS cat ON category_xref.virtuemart_category_id = cat.virtuemart_category_id WHERE () AND category.published = '1' ORDER BY content.virtuemart_product_id ASC

I have another problem with Cart Popup. The popup work but it is empty!

Here the website: http://www.indde.it/decosud

I saw your website, and you could make the module funcioanr in other languages​​, you can tell me how to do?

HI

@Qzmarcia, You need create a copy of NSP module for every language, than edit and configure it while admin panel is using a language You want to configure.

HI

@Qzmarcia, You need create a copy of NSP module for every language, than edit and configure it while admin panel is using a language You want to configure.

I'm sorry. I didn't quite understand that. Configure it how? I'm using "Shop and Buy" template.

By the way in my case the products price disappears on my products front home page only. If I change the the setting from "Tax Per Product" to "Tax Per Bill" or if I add any other rule/parameter in Tax & Calculation Rule section price disappears. It comes back if I change back to default setting. Been struggling with this one for 2 weeks now. Help! I haven't a clue... :'(

Thanks.

Hi

Please send me an ftp access, tell me the url to the page where I can see this problem and "break" it for me so I will not see the prices.

Hi

Please send me an ftp access, tell me the url to the page where I can see this problem and "break" it for me so I will not see the prices.

Hi teitbite! Sounds great! Just sent you an email with this post heading (NSPGK5 and VM2) in the subject.

Please let me know if you need anything else.

Thanks,
Mario

Oh by the way, I should mention that my ultimate goal for all this was to get both the home and products pages to show the base/or cost price only. Right now what you see is the cost with taxadded onto it as a subtotal ie...(ESSENTIAL EYEWEAR - Cost price$150+Tax= $163.31). I only want the tax to be added at point of checkout or cart stage only, not the home or products pages.The home and products page should only display cost ($150) without tax added. And I'd like to set by Country and state as well.


Thanks,
Mario

Hi

I have edited /modules/mod_news_pro_gk5/portal_modes/product_gallery_2/controller.php and in line 141 I've replaced "priceWithTax" to "basePrice" so now there is:

Code: Select all

        $news_price.= $currency->createPriceDiv('basePrice','',$product->prices);


Should be ok now. Try just add this to css to center the price after change.

Code: Select all

.gkNspPM-ProductGallery2 .gkPrice {
    text-align: center;
}


Hi

I have edited /modules/mod_news_pro_gk5/portal_modes/product_gallery_2/controller.php and in line 141 I've replaced "priceWithTax" to "basePrice" so now there is:

Code: Select all

        $news_price.= $currency->createPriceDiv('basePrice','',$product->prices);


Should be ok now. Try just add this to css to center the price after change.

Code: Select all

.gkNspPM-ProductGallery2 .gkPrice {
    text-align: center;
}


Looks good. Thats exactly what I was after. But now the products page, if you click on any of those products to take there, still show price with tax summed up.

Is there any way you can fix only the Tax & Calculation Rule interface (see screenshot) so it works where I can just set the rules automatically to affect all the pages it needs to, which would include the products page I'm assuming? Cause I'd still like to set the rule as per country and state, groups, and Product categories also, and those parameters also cause the prices to disappear as well.


Best,
Mario

Screen Shot 2013-11-06 at 6.38.27 AM.png

Actually nevermind. I just checked. It works fine!

Thank you so much teitbite! Your the man!

Hi

Great. I have just modified a module since I thought the question was about. NSP module is designed to show only one variant of the price (with tax), so simply changing the name ot the price variant was required.

Hi

Great. I have just modified a module since I thought the question was about. NSP module is designed to show only one variant of the price (with tax), so simply changing the name ot the price variant was required.

Just so you know I saw on other threads this same question coming up and never receiving an answer. So I thank you for that and I'm sure many on here do too. It didn't make any sense to a lot of us to show prices summed up with tax prior to checkout. Not even amazon does that. I think it would confuse customers or turn them off marketing-wise to see the price so high compared to other competitors who only show cost without tax.

Basically what I'm saying is that it should be a standard feature for that module to allow us that option out the gate and not make prices disappear like it did whenever we tried modifying a rule in "Tax & Calculations". It seemed like a bug in the system.

Again thank you for all your help. There was no way I could have figured that out and I was at a standstill not knowing what will I do next. So honestly a million thanks!

Hi

No problem, glad I could help.

Answering Your question about css from mail: put all css changes to override.css file just remember to allow using override in template settings. It's importand in order to be able to update the template.

Now the code. Right now it's hard to access module header since there is more than one module in sidear. There is couple of ways I cn think of, but the best in my opinion is to use a module class suffix. Try simply add a suffix for example " currencies" (space in front is important), than You will be able to access this module header with a css code like:

Code: Select all

.currencies h3.header {
color: red;
}


Hi

No problem, glad I could help.

Answering Your question about css from mail: put all css changes to override.css file just remember to allow using override in template settings. It's importand in order to be able to update the template.

Now the code. Right now it's hard to access module header since there is more than one module in sidear. There is couple of ways I cn think of, but the best in my opinion is to use a module class suffix. Try simply add a suffix for example " currencies" (space in front is important), than You will be able to access this module header with a css code like:

Code: Select all

.currencies h3.header {
color: red;
}


Great advice and thanks again! Only problem is, in which PhP file would these two particular headers be where I can add the suffix? Sorry that's really what I was having the most problem locating. Thanks!

And also where in template settings do I find Override?

IS this where and how I would apply an override?

Screen Shot 2013-11-13 at 1.10.17 PM.png

Or did you mean here?

Screen Shot 2013-11-13 at 1.19.38 PM.png

Hi

"CSS Override", we are just talking about changing the style of the header. After enabling this option in template settings You wll be able to use override.css file to put Your own code which will be chaning the site look.

Layout override is made to change width of the main content for certain pages, etc

Module class suffix needs to be added in module configuration. Differen modules gotthis option present in diffrent places but it's mostly there.

The PHP file module header is in won't help. This file is using a function so most of the modules may be using this one and adding anything there will add it for all modules at the same time.

Hi

"CSS Override", we are just talking about changing the style of the header. After enabling this option in template settings You wll be able to use override.css file to put Your own code which will be chaning the site look.

Layout override is made to change width of the main content for certain pages, etc

Module class suffix needs to be added in module configuration. Differen modules gotthis option present in diffrent places but it's mostly there.

The PHP file module header is in won't help. This file is using a function so most of the modules may be using this one and adding anything there will add it for all modules at the same time.

Cool! Gotcha! I understand now. Got it to work now. Thank you!

Hi

No problem. Glad I could help.

Hi

I have edited /modules/mod_news_pro_gk5/portal_modes/product_gallery_2/controller.php and in line 141 I've replaced "priceWithTax" to "basePrice" so now there is:

Code: Select all

        $news_price.= $currency->createPriceDiv('basePrice','',$product->prices);


Should be ok now. Try just add this to css to center the price after change.

Code: Select all

.gkNspPM-ProductGallery2 .gkPrice {
    text-align: center;
}


I added your tekst in the style.CSS in the folder /product_gallery but still no change. I turned ON the css-override-switch in the template. What am i doing wrong? I need all prices excluding tax, only in the cart when paying, the tax has to be shown.

Now i turned on the switch Use default CSS in GK5 en the right price shows !, but clicking the product and the next page shows the price including tax....
What can i change to show de basePrice in large orange text?

Hi

Please show me Your site.

http://www.sitecase.nl/testomgeving/agrokleding

I want the text "inc. tax" changed to a dutch version "BTW" (i asume if i can change that the same text will change in the orange circle when you scroll the mouse above the picture) and on the productpage i want the fontsize and color of the text "Verkoopprijs zonder BTW"(basePriceWithout Tax) in the way the "Verkoopprijs"(basePriceWith Tax) is shown and vice versa.

Customers are companys who don't pay tax(they pay, but can reclaim it), so the price in the shop has to be without tax everywhere except in the cart and on the bill.

Tx,

Kees

tax1.jpg

tax2.jpg

This is the example of the fontsize and color which i want to change with the line right under....

Hi

Ok, That's pretty detailed request. Plese better send me an access to FTP, so I'll change it for You. Will be faster this way.

Hi

I'm afraid an access You've send me is not working. Please check it and send me one more time.

530 Login incorrect. Please contact your web hosting service provider for assistance.

Hi

Finally today I was able to log in to ftp, but now I cannot find the site since http://www.sitecase.nl/testomgeving/agrokleding is not working anymore. Can You please tell me the new url ?

I did send you the new url, but the strange thing is that when i reply to you i receive the confirmation that the message has been send, but then the message is in the outbox for a couple of days and not in my send items. But my message with the right URL is in your mailbox for some days now, because its in my send items-box for a couple of days.....