Resolved Export Error 1146 using VM basepricewithtax field

Hello,

The error in your export file means that no language appears to have been chosen in the export template. In your template go to the Options page and check if a language is selected or select another language and save the template. Set the language back to what it should be and save the template again. Run the export and see how it goes.

I've also noticed there is no such field as basepricewithtax when importing VM products using CSVi only a field called price_with_tax that might be the correct one?

The base price field is not supported for import, only for export as you can see in the product pricing documentation. That is because the base price field is a non-editable field, it is a calculated field. You can use either the product_price or price_with_tax (this requires the product_tax field) field.

I simply want to update the VM 'Final price' to match the 'Cost Price' for all VM products without having to go into each individual Product and press the save button.

In that case you should not apply any tax and discount rules.

Hi

I have tried the language fix but still getting

<title>Error: 1146 Table &#039;cleverpc_gift55.s0k3r_virtuemart_products_&#039; doesn&#039;t exist SQL=SELECT `s0k3r_virtuemart_products`.*

That being the case its irrelevant anyway if I cannot overwrite the 'Base Cost' because it is calculated.

My problem therefore is simply that each product has the wrong 'Base Price' due to a configuration of currency/tax/discount that was there when the import was done but is now no longer there. There are now no currency/tax/discount rules applied to virtuemart products. As said the only way to recalculate the 'Base Price' is to go into a product with the wrong 'Base Price' and Save it. This then puts the 'Base Price' to equal the 'Cost Price' which is what is required. Going into all products individually and saving each one of them will take too long.

Is there a way of refreshing all the products at once to recalculate the 'Base Price' ?

I've tried clearing the Joomla cache without success. Is there a VM product cache that can be deleted?

Cheers

Hello,

I have tried the language fix but still getting

There is still no language present in the template then. After you selected the template from the dropdown, did you click load?

Does it happen if you re-create the template?

Is there a way of refreshing all the products at once to recalculate the 'Base Price' ?

The problem is not the base price I think because it is not stored anywhere. VirtueMart calculates the base price as soon as you open a product.

The fastest way to make sure that no tax/discount rules are associated to any prices is by running this query using PhpMyAdmin for example:

UPDATE X_virtuemart_product_prices SET product_tax_id = 0, product_discount_id = 0;

replace the X with your own prefix. After that is done, check if the base price is correct or not.

Hi

I have corrected the wrong 'Base Price' problem

I tried the following as you suggested but it did not work

UPDATE s0k3r_virtuemart_product_prices SET product_tax_id = 0, product_discount_id = 0;

I noticed however the currency id was incorrect for most products so ran

UPDATE s0k3r_virtuemart_product_prices SET product_currency = 52;

and this worked, thanks for pointing me in the right direction.

re the export Error. Having corrected above I am now getting the same errtor code but a different message about missing vendors

<title>Error: 1146 Table &#039;cleverpc_gift55.s0k3r_virtuemart_vendors_&#039; doesn&#039;t exist SQL=SELECT `s0k3r_virtuemart_vendors`.

Cheers

Hello,

Ok, an incorrect currency can throw a curve ball as well

As for the vendors, it is the same problem as the products, it is missing the language setting still. Please post some images from step by step how you run the export. Also include the images of your template settings.

Hi

If I unpublished the field basepricewithtax the template will work correctly and give an output as expected. Only when I include basepricewithtax does the error below exist.

<title>Error: 1146 Table &#039;cleverpc_gift55.s0k3r_virtuemart_vendors_&#039; doesn&#039;t exist SQL=SELECT `s0k3r_virtuemart_vendors`.*

It seems to be looking for a vendor with id 39 but that vendor does not exist in the s0k3r_virtuemart_vendors table. There is only one vendor with id 1. Also the two fields below in the same vendor record are set as 52 which is correct at GBP.

vendor_currency
vendor_accepted_currencies

Cheers

Hello,

It is not looking for ID 39, the 39 is part of the HTML code

_'

which translates to a single quote. However your remark did trigger something as I now realize this is not an error coming from CSVI itself but from VirtueMart. Also because the posted error message is just a little longer and I can see it tries to select all

SELECT `s0k3r_virtuemart_vendors`.*

. This is something CSVI doesn't do.

So what I have to figure out now is how to get VM to use the correct language table. What you have not mentioned yet, which CSVI version are you using?

VirtueMart 3.0.8

Folder Status Options
/home/cleverpc/public_html/http://giftofjewellery.co.uk/tmp Writable
/home/cleverpc/public_html/http://giftofjewellery.co.uk/tmp/com_csvi Writable
/home/cleverpc/public_html/http://giftofjewellery.co.uk/tmp/com_csvi/debug Not writable

Setting Value
Display errors Yes
Magic quotes runtime No
Magic quotes gpc No
PHP version 5.5.26
Joomla version 3.4.2
Database schema version 5.18

About
Name: CSVI Pro
Version: 5.20

You have the latest version
Coded by: RolandD Cyber Produksi
Contact: contact@csvimproved.com
Support: CSVI Homepage
Copyright: Copyright (C) 2006 - 2014 RolandD Cyber Produksi. All rights reserved.
License: GNU/GPL v3

Please download CSVI version 5.21.2 from the Download section and install it on top of the existing one. See if the issue is still there. Thanks.

Brilliant that did the trick

Many thanks for your excellent assistance in resolving my issues

Richard