Forum Replies Created

Viewing 15 replies - 16 through 30 (of 34 total)
  • Thread Starter 9ball

    (@9ball)

    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..

    Thread Starter 9ball

    (@9ball)

    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.

    Thread Starter 9ball

    (@9ball)

    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_lookup

    so 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 &

    Thread Starter 9ball

    (@9ball)

    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 CSV

    i’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 &

    Thread Starter 9ball

    (@9ball)

    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’s

    thought 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.

    Thread Starter 9ball

    (@9ball)

    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 &amp: 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 &amp:

    wp:postmeta
    wp:meta_value><![CDATA[TESTINGTSHIRTBLACK&amp;CREAMSMALL]]

    Thread Starter 9ball

    (@9ball)

    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&amp;CREAMXLARGE
    variation SKU TESTINGTSHIRTBLACK&amp;CREAMLARGE
    variation SKU TESTINGTSHIRTBLACK&amp;CREAMMEDIUM
    variation SKU TESTINGTSHIRTBLACK&amp;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 &amp; 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&amp;CREAMXLARGE
    variation SKU TESTINGTSHIRTBLACK&amp;CREAMLARGE
    variation SKU TESTINGTSHIRTBLACK&amp;CREAMMEDIUM
    variation SKU TESTINGTSHIRTBLACK&amp;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 &amp; 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 &amp; in woocommerce product search then it finds them.
    Thread Starter 9ball

    (@9ball)

    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 &amp; 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 1

    now seem the database has changed SKU’s back again and added the amp; after the test import

    BLACK&amp;CREAM-S
    BLACK&amp;CREAM-M
    BLACK&amp;CREAM-L

    Seem it maybe an import issue.

    Thread Starter 9ball

    (@9ball)

    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

    Thread Starter 9ball

    (@9ball)

    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-X

    but it’s only the “variation” SKU’s that adding amp; to the CVS file: BLACK&amp;CREAM1

    variable BLACK&CREAM-X
    variation BLACK&amp;CREAM-S
    variation BLACK&amp;CREAM-M
    variation BLACK&amp;CREAM-L

    i 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&amp;CREAM1

    but the Parent variable SKU shows ok and amp; isn’t being added on the export CSV: BLACK&CREAM-X

    Thread Starter 9ball

    (@9ball)

    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

    Thread Starter 9ball

    (@9ball)

    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…

    Thread Starter 9ball

    (@9ball)

    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

    Thread Starter 9ball

    (@9ball)

    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.

    Thread Starter 9ball

    (@9ball)

    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..

Viewing 15 replies - 16 through 30 (of 34 total)