"Product Variation already exists" on import, but no variation on WooCommerce UI

  • Resolved syaowee

    (@syaowee)


    8 years, 3 months ago

    Hi there — When I merged the product variations, not all variations were successfully merged: https://prnt.sc/c7p6rx

    A little background

    – this is not the first time we uploaded the products and product variations. (because client changed her mind over product grouping several times since I first uploaded products in June/July.)

    – Last week, I deleted all products (which may have ended up orphaning variations). When I uploaded the updated products, they all uploaded successfully. BUT when I uploaded product variations as new (not merged), we got errors that variations already exist. However, when you edit the product, there are NO variations.

    – We tried: a) deleting variations from WordPress/WooCommerce interface; b) https://gist.github.com/pmgarman/6135967; c) DB and post meta; d) restore backup, then delete variations first, then delete products so the variations don’t get orphaned; e) delete WooCommerce and reinstall it. None of these worked.

    Micro-Fiber Cloth — ALL variations uploaded fine in the past. But today, some were imported, some were not.
    – “Product Variation already processed” –> I shouldn’t get this error because Line 622 and Line 623 have different attributes and prices for product SKU MF1621-GR.

    Mesh Laundry Bag — says variation already exists, but when you click on Edit Product, there are no variations.

    ==============================================
    akaylinens.codelessme.net/shop/

    ### WordPress Environment ###

Home URL: https://akaylinens.codelessme.net
Site URL: https://akaylinens.codelessme.net
WC Version: 2.6.4
Log Directory Writable: ?
WP Version: 4.6
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US

### Server Environment ###

Server Info: Apache/2.2.24 (Unix) mod_hive/5.0 mod_ssl/2.2.24 OpenSSL/1.0.0-fips mod_auth_passthrough/2.1 mod_bwlimited/1.4 mod_fastcgi/2.4.6 mod_fcgid/2.3.6
PHP Version: ? 5.4.45 - We recommend a minimum PHP version of 5.6. See: How to update your PHP version
PHP Post Max Size: 32 MB
PHP Time Limit: 0
PHP Max Input Vars: 20000
cURL Version: 7.49.1
OpenSSL/1.0.2h

SUHOSIN Installed: –
MySQL Version: ? 5.5.31 - We recommend a minimum MySQL version of 5.6. See: WordPress Requirements
Max Upload Size: 24 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 2.6.4
:
woocommerce_sessions: ?
woocommerce_api_keys: ?
woocommerce_attribute_taxonomies: ?
woocommerce_downloadable_product_permissions: ?
woocommerce_order_items: ?
woocommerce_order_itemmeta: ?
woocommerce_tax_rates: ?
woocommerce_tax_rate_locations: ?
woocommerce_shipping_zones: ?
woocommerce_shipping_zone_locations: ?
woocommerce_shipping_zone_methods: ?
woocommerce_payment_tokens: ?
woocommerce_payment_tokenmeta: ?
MaxMind GeoIP Database: ?

### Active Plugins (36) ###

ManageWP - Worker: by ManageWP – 4.2.9
All-in-One WP Migration: by ServMask – 5.49
BAW Login/Logout menu: by Juliobox – 1.3.3
Beaver Builder Plugin (Agency Version): by The Beaver Builder Team – 1.8.1
Better Search Replace: by Delicious Brains – 1.2.10
EWWW Image Optimizer: by Shane Bishop – 2.9.6
FormCraft: by nCrafts – 3.2.11
Grid/List View for WooCommerce: by BeRocket – 1.0.2
iFlyChat: by iFlyChat Team – 4.0.3
MAYO - Login Screen: by Passion In Design – 1.3
Menu Icons: by Dzikri Aziz – 0.10.1
Popup Maker: by WP Popup Maker – 1.4.18
WooCommerce Product Carousel Slider: by ADL Plugins – 2.0
Rename wp-login.php: by Ella Iseulde Van Dorpe – 2.5.5
Simple Mail Address Encoder: by Bannerweb GmbH – 1.5.4
Stripe WooCommerce Addon: by Syed Nazrul Hassan – 1.0.8
Ultimate WooCommerce Brands: by MagniumThemes – 1.1.1
Use Any Font: by Dinesh Karki – 4.5.1
Use Google Libraries: by Jason Penney – 1.6.2.1
WaspThemes - Yellow Pencil Pro: by WaspThemes – 5.1.2
Advanced AJAX Product Filters for WooCommerce: by BeRocket – 1.1.5
WooCommerce Dynamic Pricing: by Lucas Stark – 2.11.1 – 2.11.6 is available
Woocommerce LightBox: by wpbean – 1.03
WooCommerce Menu Cart: by Jeremiah Prummer
Ewout Fernhout – 2.5.7

WooCommerce Product CSV Import Suite: by WooThemes – 1.10.10
WooCommerce UPS Shipping: by WooThemes – 3.1.2 – 3.1.3 is available
WooCommerce USPS Shipping: by WooThemes – 4.3.2 – 4.3.3 is available
WooCommerce: by WooThemes – 2.6.4
WordPress Importer: by wordpressdotorg – 0.6.1
Yoast SEO: by Team Yoast – 3.4.2
WP Team Showcase and Slider: by WP Online Support – 1.2
Yeloni Exit Popup: by Jayasri Nagrale – 3.9.1
YITH WooCommerce Ajax Product Filter: by YITHEMES – 3.0.8
YITH WooCommerce Product Slider Carousel: by YITHEMES – 1.0.11
YITH WooCommerce Wishlist: by YITHEMES – 2.0.16
YITH WooCommerce Zoom Magnifier: by YITHEMES – 1.2.21

### Settings ###

Force SSL: –
Currency: GBP (￡)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2

### API ###

API Enabled: ?

### WC Pages ###

Shop Base: ? Page not set
Cart: ? Page not set
Checkout: ? Page not set
My Account: ? Page not set

### Taxonomies ###

Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

### Theme ###

Name: Beaver Builder Child Theme
Version: 1.0
Author URL: https://www.fastlinemedia.com
Child Theme: ?
Parent Theme Name: Beaver Builder Theme
Parent Theme Version: 1.5.1
Parent Theme Author URL: https://www.wpbeaverbuilder.com/?utm_medium=bb-pro&utm_source=bb-theme&utm_campaign=themes-admin-page
WooCommerce Support: ?

### Templates ###

Overrides: bb-theme-child/woocommerce/archive-product.php
bb-theme-child/woocommerce/content-product.php version 2.5.0 is out of date. The core version is 2.6.1
bb-theme-child/woocommerce/single-product/related.php
bb-theme-child/woocommerce/single-product/short-description.php

: Learn how to update outdated templates

    ===============================================

    https://www.ads-software.com/plugins/woocommerce/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Caleb Burks

    (@icaleb)

    Automattic Happiness Engineer

    Same issues occur if you disable all plugins except for WooCommerce and your import plugin and switch to a default theme?

    Also, try running the select query again to see if any orphans still exist: https://gist.github.com/pmgarman/6135967

    ___

    If still stumped after trying the above, contact the plugin authors of your import plugin – which looks to be WooThemes. They have a premium support channel that you can use at WooCommerce.com. It’s against the forum rules here to support premium products.

    Thread Starter syaowee

    (@syaowee)

    Hi Caleb — I super appreciate the response! I really thought it was a WooCommerce issue until you mentioned the import plugin (which I totally forgot about, haha!)

    I didn’t get the chance to contact WooThemes anymore because in the end, our devs discovered the issue: it was a duplicate SKU error (which worked during our first few uploads/merges, but stopped working right after I deleted and re-imported products).

    I had the variations use the Parent SKU, and now the variations uploads are working again.

    Thank you so much again for your time and thoughts! (And I’m very sorry for missing the import plugin!) Marking this issue as resolved.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘"Product Variation already exists" on import, but no variation on WooCommerce UI’ is closed to new replies.