jackmatfurniturewarehouse

Morning, This code worked. Thank you

Afternoon,

https://furniture-warehouse.co.za/product/grandeur-plasma-1750-x-580-veneer-light-mahogany/

https://furniture-warehouse.co.za/product-category/tv-plasma-units/

Afternoon,

It is checked.

Good morning,

The first line is the variable the rest variations.
I am trying to edit Column M.

Link to the product:
https://furniture-warehouse.co.za/product/chesterfield-3-4-bed-standard-xl-various-leatherette-or-leather-options/

• This reply was modified 3 years, 1 month ago by jackmatfurniturewarehouse.

Hi, I hope this helps
https://drive.google.com/file/d/1U3Bvcw2XRn0hfb18C3g7Cw6FTjRxhpK-/view?usp=sharing

• This reply was modified 3 years, 1 month ago by jackmatfurniturewarehouse.

How do I paste the Excel file in my reply?

Morning, thank you for your reply.

I exported the doc so the formats are correct.

### WordPress Environment ###

WordPress address (URL): https://furniture-warehouse.co.za
Site address (URL): https://furniture-warehouse.co.za
WC Version: 6.2.0
REST API Version: ? 6.2.0
WC Blocks Version: ? 6.7.3
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.1.0
Log Directory Writable: ?
WP Version: 5.9
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.27
PHP Post Max Size: 128 MB
PHP Time Limit: 240
PHP Max Input Vars: 3500
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 10.3.32-MariaDB-cll-lve
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.2.0
WC Database Prefix: wp_
Total Database Size: 1090.17MB
Database Data Size: 528.28MB
Database Index Size: 561.89MB
wp_woocommerce_sessions: Data: 2.79MB + Index: 0.08MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Data: 1.42MB + Index: 0.50MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 5.73MB + Index: 4.04MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 5.02MB + Index: 7.36MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 4.03MB + Index: 2.94MB + Engine InnoDB
wp_commentmeta: Data: 0.17MB + Index: 0.14MB + Engine MyISAM
wp_comments: Data: 2.59MB + Index: 0.69MB + Engine MyISAM
wp_duplicator_packages: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_e_submissions: Data: 0.13MB + Index: 0.30MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.11MB + Index: 0.03MB + Engine InnoDB
wp_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_fbv_attachment_folder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_litespeed_img_optm: Data: 12.52MB + Index: 7.03MB + Engine InnoDB
wp_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_nextend2_image_storage: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_nextend2_section_storage: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_nextend2_smartslider3_generators: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_nextend2_smartslider3_sliders: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_nextend2_smartslider3_sliders_xref: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_nextend2_smartslider3_slides: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_options: Data: 14.61MB + Index: 2.31MB + Engine MyISAM
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 105.01MB + Index: 44.90MB + Engine MyISAM
wp_posts: Data: 29.93MB + Index: 6.55MB + Engine MyISAM
wp_termmeta: Data: 0.21MB + Index: 0.16MB + Engine MyISAM
wp_terms: Data: 0.10MB + Index: 0.18MB + Engine MyISAM
wp_term_relationships: Data: 0.65MB + Index: 1.53MB + Engine MyISAM
wp_term_taxonomy: Data: 0.22MB + Index: 0.15MB + Engine MyISAM
wp_usermeta: Data: 23.54MB + Index: 12.46MB + Engine MyISAM
wp_users: Data: 1.36MB + Index: 1.65MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 2.52MB + Index: 1.72MB + Engine InnoDB
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 1.22MB + Index: 0.88MB + Engine InnoDB
wp_wc_order_stats: Data: 1.36MB + Index: 0.47MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 3.52MB + Index: 6.73MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wps_hit: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wps_index: Data: 225.23MB + Index: 371.69MB + Engine MyISAM
wp_wps_key: Data: 2.14MB + Index: 3.15MB + Engine MyISAM
wp_wps_object_term: Data: 28.23MB + Index: 57.31MB + Engine InnoDB
wp_wps_object_type: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wps_query: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wps_uri: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wps_user_agent: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wsluserscontacts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wslusersprofiles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yith_wcbm_badge_rules_associations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yith_wcwl: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.11MB + Index: 0.14MB + Engine InnoDB
wp_yoast_indexable: Data: 45.42MB + Index: 20.59MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 3.11MB + Index: 4.25MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
wp_yoast_prominent_words: Data: 0.25MB + Index: 0.47MB + Engine InnoDB
wp_yoast_seo_links: Data: 4.10MB + Index: 0.75MB + Engine MyISAM
wp_yoast_seo_meta: Data: 0.18MB + Index: 0.18MB + Engine MyISAM

### Post Type Counts ###

amn_mi-lite: 1
attachment: 10691
custom_css: 4
customize_changeset: 2
elementor_library: 48
nav_menu_item: 195
oembed_cache: 77
page: 67
popup: 1
popup_theme: 6
post: 5
product: 1218
product_variation: 30595
revision: 7008
shop_coupon: 3
shop_order: 4478
team: 4
watermark_rule: 2
wp_global_styles: 1
yith-wcbm-badge: 13
ywcbm-badge-rule: 2

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (27) ###

ManageWP – Worker: by GoDaddy – 4.9.13
WooCommerce Fevertree Payment Gateway: by FeverTree Developer –
Click to Chat: by HoliThemes – 3.8
Duplicator: by Snap Creek – 1.4.4
Elementor Pro: by Elementor.com – 3.6.2
Elementor: by Elementor.com – 3.5.5
Enable Media Replace: by ShortPixel – 3.6.3
GA Google Analytics: by Jeff Starr – 20220124
Site Kit by Google: by Google – 1.50.0
Health Check & Troubleshooting: by The www.ads-software.com community – 1.4.5
Insert Headers and Footers: by WPBeginner – 1.6.0
WooCommerce Fevertree Installment Calculator: by FeverTree Developers –
JetElements For Elementor: by Crocoblock – 2.6.2
Manage Notification E-mails: by Virgial Berveling – 1.8.2
NitroPack: by NitroPack LLC – 1.5.9
SR Product 360° View: by superrishi – 3.3
TP Product Image Flipper for Woocommerce: by TP Plugins – 1.0.5
WebP Converter for Media: by Mateusz Gbiorczyk – 4.2.0
Advanced Order Export For WooCommerce: by AlgolPlus – 3.2.2
WooCommerce Product Search: by itthinx – 4.4.0
WooCommerce: by Automattic – 6.2.0
Yoast SEO Premium: by Team Yoast – 18.0
Yoast SEO: by Team Yoast – 18.1
Asset CleanUp: Page Speed Booster: by Gabe Livan – 1.3.8.5
Yoast SEO: WooCommerce: by Team Yoast – 14.6
YITH WooCommerce Badge Management Premium: by YITH – 2.2.0
YITH WooCommerce Wishlist: by YITH – 3.6.0

### Inactive Plugins (3) ###

MainWP Child: by MainWP – 4.1.9
WooCommerce Fevertree ProductsCache: by FeverTree Developer –
WooCommerce Product Archive Customiser: by jameskoster – 1.0.5

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Must Use Plugins (2) ###

Health Check Troubleshooting Mode: by – 1.7.2
ManageWP – Worker Loader: by GoDaddy –

### Settings ###

API Enabled: ?
Force SSL: –
Currency: ZAR (R)
Currency Position: left
Thousand Separator:
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: ?

### WC Pages ###

Shop base: #13672 – /shop/
Cart: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
Checkout: #17 – /checkout/
My account: #14 – /furniture-warehouse/my-account/
Terms and conditions: #4742 – /company-info/terms-and-conditions/

### Theme ###

Name: Hello Elementor Child
Version: 2.3.0.1595432312
Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
Child Theme: ?
Parent Theme Name: Hello Elementor
Parent Theme Version: 2.4.2 – 2.5.0 is available
Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
WooCommerce Support: ?

### Templates ###

Overrides: hello-elementor-child/woocommerce/emails/customer-on-hold-order.php
hello-elementor-child/woocommerce/loop/result-count.php version 3.3.0 is out of date. The core version is 3.7.0

Outdated Templates: ?

Learn how to update

### Action Scheduler ###

Complete: 14,668
Oldest: 2022-01-15 09:11:46 +0200
Newest: 2022-02-15 08:37:29 +0200

Failed: 10
Oldest: 2021-06-09 10:54:17 +0200
Newest: 2022-02-10 11:34:49 +0200

### Status report information ###

Generated at: 2022-02-15 09:05:10 +02:00
`

I cant paste my CSV file?