[GeorgeK]

I finally got it working.

Here’s how:

– I uploaded the .csv file to my website via cPanel file manager.

– I used the WP CSV/DB plugin, and selected:

Upload ==> From URL ==> Audio, Video, or Other File ==> Insert into post

Just FYI… Even when I download https://www.tipsandtricks-hq.com/ecommerce/wp-content/uploads/products.csv and then try to upload it via the plugin’s interface, I get the error “This is not a valid .csv file extension.”

Maybe this is related to https://wordpress.org/support/topic/this-is-not-a-valid-csv-file-extension/

Anyway, thanks again for the great plugins!

[GeorgeK]

Hi, Keith!

The error in the screenshot says “#1366 – Incorrect integer value: ” for column ‘ppv_content’ at row 1″

I’m not sure what the issue could be there.

The first row of that column says “ppv_content” (without the quotes) and then every cell in that row says “0” (again, without the quotes).

I even tried creating this on Google Sheets, downloading it as .csv, and importing it via the WP CSV/DB plugin and it says “This is not a valid .csv file extension.”

Is it possible a php extension is missing on my host?

Thanks!

[GeorgeK]

Thanks for the reply.

Yes, and yes.

The page with the image I posted in my previous post seems to not always be available, due to Cloudflare timing out.

Here it is again:

ibb.co/Y3rWsS3

Thanks!

[GeorgeK]

Hello…

Two months later, I’m updating this thread, because I’m facing a similar issue.

I try to upload a csv file via the WP CSV/DB plugin.

I get this error:

“This is not a valid .csv file extension”.

When I try to upload via PHPMyAdmin, I see this:

imgsafe.org/image/a4c9871502

It says “36 products executed”.

However, no products are actually added to the eStore backend (there are already 20 products there, and they remained 20).

I created this csv by exporting the initial products, adding some more, and then importing. It’s the exact same process that allowed me to successfully import products two months ago.

Any idea what mistake(s) I’m making?

Thanks!

[GeorgeK]

I see it now, Keith – thanks!

[GeorgeK]

Ok, thanks, Keith.

[GeorgeK]

Hi, Keith!

I understand.

Maybe a simple text field could be added to the checkout that says something like “This purchase is for a registered business” or “have a VAT id?”, like so:

imgur.com/cpIpn1r

If the buyer checks it, the Paypal VAT addition gets disabled (or something similar).

I feel this addition to eStore might make it an even more compliant and viable solution for online merchants – plus allow it to take an even bigger market share.

Thanks!

George

[GeorgeK]

Keith, I really appreciate your answer – very helpful!

Thanks,

George

[GeorgeK]

Thanks for the reply, Keith!

A couple of technical questions, (if you don’t mind)…

1) Could you perhaps provide data structure and examples for the $cart_items parameter of the eStore_product_database_updated_after_payment filter?

Mainly, we are looking for the “Reference Text” field of each item – as that will be a sales item ID which we will pass to our own anti-piracy app.

2) What would happen if we fire HTTP error from the eStore_product_database_updated_after_payment filter? Will this cause PayPal to resend IPN later? Just trying to find the best way to handle any failed attempts to add a record to our app.

Thanks again and sorry for the technical questions – I love the WP eStore plugin.

George

[GeorgeK]

One (early) question from one of our developers:

“Does WP eStore fire order completion event which we could handle?

If yes, are there any developer docs on customizing the plugin with external event handlers?”

Thanks!

George

[GeorgeK]

Thanks for the reply, Keith!

Not to be daft, but where can I find this thank-you page function? You obviously aren’t referring to the “Return URL” text filed inside WP eStore. Your great plugin has many functions.

Thanks!

George

[GeorgeK]

Thanks for the reply, Keith.

Ok, no problem.

Sorry for my mis-formatted initial post, btw!

Have a great day.

George

[GeorgeK]

Thanks for the reply, Keith…

Yeah, I had used the existing template products.csv and followed the instructions in your video https://www.youtube.com/watch?v=M_5h25UZFZI

I finally got it working by manually adding one product, exporting the MySQL table as CSV, adding the new info, and then importing via PHPMyAdmin.

Thanks for the help – great plugins!

George

[Author]

Posts