9ball
Forum Replies Created
-
HI,
Thanks Peter for the message, basic HTML/CSS custom code and using premade snippets code is as far as my coding skills goes.
possibly best for me to deactivate Wordfence 2FA for customers, and maybe find a different 3rd party plugin 2FA just for Woocommerce customers to use within their admin/dashboard .Thanks anyway..
Forum: Plugins
In reply to: [WooCommerce] CSV Export & Ampersand now changed to &Hi,
The SKU “&” or ampersand within the SKU’s are coming from my wholesale suppliers auto daily feed CSV.
as i update my Products Stock Qty by their SKU’s, due to the wholesales CSV Product ID isn’t the same as my Product ID’s.
i will give my wholesales a heads up about & ampersands within their SKU’s, now i know someone other than me can replicate the issue. (if they really care or read my email is another thing.)Big thanks for your help, it’s good to know am not going mad.
Forum: Plugins
In reply to: [WooCommerce] CSV Export & Ampersand now changed to &to add to the above, when the CSV export shows: &
i deleted the one product from within Admin WooCommerce products.but looking at the database the product is still showing and hasn’t been removed /deleted in:
_postmeta
wc_product_meta_lookupso even by recreating the product again manually or by upload CSV, even after it been deleted from within the Admin woocommerce side, if using the same SKU’s but without the amp;
the product that’s still within the database with & seems to over righting the newly made product.
so on the next CSV export it will again have amp; added to the &Forum: Plugins
In reply to: [WooCommerce] CSV Export & Ampersand now changed to &hi,
i’ve used :
Google doc’s saved as save as comma separated CSV
Openoffice V4.1.15 opened as UTF-8 CSV and saved has UTF-8 CSV
Modern CSV saved as UTF-8 CSV
Excel saved as comma separated CSVi’ve even tried changing the woocommerce import to Character encoding of the file upload using UTF-8 before importing.
today
1, i used Google doc’s only to import the product, and it imported ok,
2, i then exported the CSV in woocommerce and opened up in google doc’s changed the price and stock amount, saved as CSV and reimported, import ok.
i then re-exported a CSV again within woocommerce opened up in google docs, and again the & has now changed to &
Forum: Plugins
In reply to: [WooCommerce] CSV Export & Ampersand now changed to &HI,
After setting up a subdomain with new database, and new wordpress, and WooCommerce
here’s what i found..
i created a product manually with Variations. with colour, size stock, price etc
all the variation SKU’s had a” & “within them.i exported the woocommerce CSV file and it all looks fine, and No &
showing up on the CSV file SKU’sthought i had sorted it…until
if i update the opened CSV file, and change the Stock qty amount and change the prices
and save and upload the CSV file as it was downloaded with all columns’and Tick the box “Existing products that match by ID or SKU will be updated. Products that do not exist will be skipped.”
everything seems to upload ok, until i redo a new export woocommerce CSV file to check the new stock qty and new prices have updated.
now all the SKU’s have a & on the CSV file.
Forum: Plugins
In reply to: [WooCommerce] CSV Export & Ampersand now changed to &hi,
the product was made manually within WooCommerce add product, and not by importing a CSV file, it’s the exported CSV file that has issues.
even if i import a CSV it works ok, but as soon as i export a CSV file, its got the &: added, Which wasn’t on the import or when added the product manually.
i even tried the wordpress tools export XML ” Variations” and even this XML export file shows the SKU’s with &:
wp:postmeta
wp:meta_value><![CDATA[TESTINGTSHIRTBLACK&CREAMSMALL]]Forum: Plugins
In reply to: [WooCommerce] CSV Export & Ampersand now changed to &hi,
Live website, WooCommerce > Status > Logs. No Fatal Errors.
i setup a Staging site, which runs within the hosting website root
Clean WordPress Version: 6.5.5 install using WPvivid Plugins - Staging
Using a Clean database auto setup within Cpanel:
PHP version: 8.1.28
Server connection collation: utf8mb4_unicode_520_ci
Charset: utf8mb4
Default Theme: Twenty Twenty-Three
Woocommerce Version 9.0.2 (No other plug-ins are installed)
Added only One variable product, with default Price, Stock, Colour and Size
variable SKU TESTINGTSHIRTBLACK&CREAMSHORT-G
variation SKU TESTINGTSHIRTBLACK&CREAMXLARGE
variation SKU TESTINGTSHIRTBLACK&CREAMLARGE
variation SKU TESTINGTSHIRTBLACK&CREAMMEDIUM
variation SKU TESTINGTSHIRTBLACK&CREAMSMALL
then exported the Standard Woocommerce CSV and the SKU's have now show a added amp;
variation SKU TESTINGTSHIRTBLACK&CREAMXLARGE
variation SKU TESTINGTSHIRTBLACK&CREAMLARGE
variation SKU TESTINGTSHIRTBLACK&CREAMMEDIUM
variation SKU TESTINGTSHIRTBLACK&CREAMSMALL
Opened the CSV file in Libreoffice, Mordern CSV, Excel, always the same.
seems looking at the the phpMyAdmin database has also changed to be & after the product was added and saved.
Issues:
1, cant update the Stock using the variation SKU TESTINGTSHIRTBLACK&CREAMXLARGEhi,
Live website, WooCommerce > Status > Logs. No Fatal Errors.
i setup a Staging site, which runs within the hosting website root
Clean WordPress Version: 6.5.5 install using WPvivid Plugins - Staging
Using a Clean database auto setup within Cpanel:
PHP version: 8.1.28
Server connection collation: utf8mb4_unicode_520_ci
Charset: utf8mb4
Default Theme: Twenty Twenty-Three
Woocommerce Version 9.0.2 (No other plug-ins are installed)
Added only One variable product, with default Price, Stock, Colour and Size
variable SKU TESTINGTSHIRTBLACK&CREAMSHORT-G
variation SKU TESTINGTSHIRTBLACK&CREAMXLARGE
variation SKU TESTINGTSHIRTBLACK&CREAMLARGE
variation SKU TESTINGTSHIRTBLACK&CREAMMEDIUM
variation SKU TESTINGTSHIRTBLACK&CREAMSMALL
then exported the Standard Woocommerce CSV and the SKU's have now show a added amp;
variation SKU TESTINGTSHIRTBLACK&CREAMXLARGE
variation SKU TESTINGTSHIRTBLACK&CREAMLARGE
variation SKU TESTINGTSHIRTBLACK&CREAMMEDIUM
variation SKU TESTINGTSHIRTBLACK&CREAMSMALL
Opened the CSV file in Libreoffice, Mordern CSV, Excel, always the same.
seems looking at the the phpMyAdmin database has also changed to be & after the product was added and saved.
Issues:
1, i can't update the Stock using the SKU's TESTINGTSHIRTBLACK&CREAMXLARGE ect ect as the products SKU's do not exist to update.
2, i can't even search in WooCommerce products for the variation SKU's as the product do not exist.
3, if you search for the SKU's with the & in woocommerce product search then it finds them.Forum: Plugins
In reply to: [WooCommerce] CSV Export & Ampersand now changed to &i thought i had sorted it, now the only way to update the stock qty for the variation SKU’s that have a “&” within the SKU’s is by using the ID number.
if i try to use the variation SKU’s with & or without amp; the the woocommerce importer can’t find the products /SKU’s at all.
even though i changed the SKU’s within the database and removing the amp; after importing a test CSV file with the correct ID, SKU, Stock
id type sku stock
123 variation BLACK&CREAM-S 1
456 variation BLACK&CREAM-M 1
789 variation BLACK&CREAM-L 1now seem the database has changed SKU’s back again and added the amp; after the test import
BLACK&CREAM-S
BLACK&CREAM-M
BLACK&CREAM-LSeem it maybe an import issue.
Forum: Plugins
In reply to: [WooCommerce] CSV Export & Ampersand now changed to &i used the default WooCommerce importer/exporter and used different other editors with no luck.
i also couldn’t replicate this issue on my other websites. (which are 99% the same setup).
As i couldn’t find what the issues was, i had to edit the database SKU’s manually re-editing them and removing the amp; from the variations SKU’s with &
Now seems to be exporting the CSV variation SKU’s for the product with &…. ok
Forum: Plugins
In reply to: [WooCommerce] CSV Export & Ampersand now changed to &hi,
I am using Microsoft Excel, but i don’t think that is the issue.
As the variable Parent SKU’s shows correctly on the exported CSV file as: BLACK&CREAM-Xbut it’s only the “variation” SKU’s that adding amp; to the CVS file: BLACK&CREAM1
variable BLACK&CREAM-X
variation BLACK&CREAM-S
variation BLACK&CREAM-M
variation BLACK&CREAM-Li did remove the products and manually re-added the product and all variations SKUs and exported the CSV again and opened within windows 11 Notepad /txt file.
and is still showing the: BLACK&CREAM1but the Parent variable SKU shows ok and amp; isn’t being added on the export CSV: BLACK&CREAM-X
Hi,
just the standard, Woocommerce products import / export which as far as i can tell doesnt have anyway to exclude the meta fields / columns off the CSV file
Hi,
Found the issue with the email template now showing WooCommerce template, due to ( somehow WooCommerce Email notifications, had become “disabled” on the New account in Woocommerce email settings.
Thanks for the help…
forgot to add, when testing, i switched on:
Woocommerce – When creating an account, send the new user a link to set their password.the email layout is still Woocommerces templte, and i cant seem to edit this template email,
email Subject: Thanks for registering with us a account has been created!email doesn’t seem to use the default setup: Default template from Email Template Customizer for WooCommerce
HI,
Sorry for my confusion, as I’ve been testing again myself after your message.
Yes you are correct, emails sent from the wordpress admin side “Add new user” emails sent to all different “Roles” do send the password by URL links.My confusion was, that if a customer signs up from the front end, it seems to use the same email template and the password is viewable in the traditional format.
if i was to remove the “Your password is: {user_password}”
off the template and replace it with a button” Reset you password if needed: {reset_password_url}”Would this work for both admin emails and the front end emails and take them to correct URL
Personally the long URLs don’t look nice in the emails, and the customers password totally viewable in the traditional format isn’t good for password security.
Hi,
When you say security reason, WordPress 6.5.X does not allow to display under the traditional format
Do you mean all emails or just the admin emails?
Right now:
1, When the customer receives the email the passwords is showing as a traditional format, Not an URL address.
2, But when the same email is sent to a new Admin is shows a URL address and doesn’t show the traditional format.is this how it should work..