Resolved Delete products via cron?

Hello Donna,

Can you think of any way this can be achieved through CSVI?

Sure I can

You create an import template with 2 fields, product_sku and product_delete. You map the product_sku to your product sku and the product_delete to the text field. You create a replacement rule where you replace Discontinued to Y and another replacement rule where you replace Out of Stock and In Stock to N. Assign these replacement rules to the product_delete field. All done.

That should delete the discontinued products. Of course, make sure to test it

Thanks Rolandd,

I have set this up and all seems well until i click 'Start Import' i then get an error stating 'Table jos_virtuemart_products_ has not been found. Check your database to see if the table exists.' It seems that there is an extra _ being apeended at the end of the table name? Any ideas?

Thanks again

Regards
Donna

Hello Donna,
You dont seem to have latest version of CSVI. This error handling has been fixed in the latest version, try updating to CSVI 6.5.6. Also the error is because you dont have language set in your template. In your template settings, on options tab make sure language is selected, save the template and then try doing the import.

Thank you, the language is set correctly in the template, so i can't see this being the issue. I cannot update at present as i am on Joomla 3.4.8 and version 6.5.6 isn't compatible. My update to 3.5 isn't scheduled to be complete yet due to my availability. Is there anything i can do in the meantime?

I have just ran this again and i have a slightly different error:

Table 'jos_virtuemart_products_sq_al' doesn't exist SQL=DELETE FROM jos_virtuemart_products_sq_al WHERE virtuemart_product_id = 11

I'll keep investigating.

Best Regards
Donna

Hello Donna,

The message you are seeing is, as Tharuna pointed out, due to the template not having a language set. After the underscore you would expect something like en_gb if that is your language. Does resaving the template help?

No need to update at this point, the only change we made in the newer version is a more explanatory message when this issue comes up.

Ok, I'll hang back trying to push through my joomla upgrade. I resaved the template and received the error posted above in my edit. I only have a single language in my store, i have unistalled the others as i do not require them, thus the only option is for en-gb to be selected. I have just resaved again and still its is looking for the 'jos_virtuemart_products_sq_al' table to delete from?

Thank you

Donna

Hello Donna,

Perhaps an open door but you are using the correct template ID in your cron job call?

I havent yet set it to run as a cron, i am just attempting to run it manually so i can check it runs as required?

Regards
Donna

Hello Donna,

That makes it kind of weird though that you only have English installed but the export says to export in Arabic. This isn't making much sense to me

Can you go to Maintenance -> Maintenance and choose CSVI Pro -> Backup templates and make a backup of this template you are using and post it here?

I would like to see if there is anything odd with the template. If needed I can change it and post a new template here for you.

No Problem,
Please find the template xml attached

Best Regards
Donna

Also, is it possible to change my username? I don't really want my email address on show. Lol!

Regards
Donna

Hello Donna,

Send me a private message with the username you want to use and I can change it. The template I will take a look at it.

Hello Donna,

Your username has been changed, so you can use that now to login. Now to the real problem. I restored the template from the XML you provided and it ran without issues. Could you do the same? Via Maintenance -> Maintenance -> CSVI Pro -> Restore template, restore this template and then run the import. You will have 2 templates with the same name so you may want to change the name of the existing template so you know which is which.

If this still tries to load Arabic or another language of it's choosing, please private message me Joomla and FTP login and I will take a closer look.

Hi rolandd, apologies i was in a meeting. I have set up some login's for you. Let me know if you have any issues.

Regards
Donna

Hello Donna,

I haven't heard back from you but was wondering if the issue(s) have been resolved.

Good Morning Rolandd

I've been working on another project for the last week, i have set up a dev site and that seems to be running slow also, so i need to have a look at some of my php settings i think, as i am using a subdomain.This is still a priority for me so i will keep you posted on my progress.

Best Regards
Donna