woocommerce/woocommerce-product-tables-feature-plugin

Stars
192
Rank 202,019 (Top 4 %)
Language
PHP
License
GNU General Publi...
Created about 7 years ago
Updated 24 days ago

woocommerce/woocommerce-product-tables-feature-plugin

woocommerce

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Implements new data-stores and moves product data into custom tables, with a new, normalised data structure.

WooCommerce Product Tables

This is the development repository for our feature plugin to replace WooCommerce product meta data with custom tables. This feature plugin is currently only available on GitHub, but will move to WordPress.org when more stable.

Since we implemented CRUD objects in WooCommerce core, our plan has been to use that abstraction to change core data structures for performance reasons. This project brings about those changes.

Data stucture

This plugin creates dedicated tables for WooCommerce data.

wc_products - Stores product data such as price, stock, and type. This replaces meta data. Products are linked to POSTS by ID still so some backwards compatibility is maintained.
wc_product_attributes - Stores attributes assigned to products. This includes custom attributes, and global attributes (taxonomies).
wc_product_attribute_values - Store attribute terms/values assigned to products.
wc_product_downloads - Stores downloadable files assigned to downloadable products.
wc_product_relationships - Lookup table to map images, grouped products, upsells, and other relations between products by ID.
wc_product_variation_attribute_values - Specifically for variations, this stores the attribute value assigned to a variation. e.g. Color = blue.

Compatibility

With data moving to custom tables, WordPress based functions which query data directly will ultimately not be compatible with this new way of doing things. This is why the CRUD was implemented first to act as a method of abstraction.

A basic compatibility layer will map meta data to custom tables if legacy plugins try to do that, however, this can only work so far. Things such as direct SQL queries, or using WP_Query without going through WooCommerce may no longer be compatible.

In terms of data, we aim to have both on the fly and bulk migration of data into the new structures.

Get involved

This project is a large undertaking, and we believe it to be a neccessary one. This project should serve as a template for other objects in WooCommerce and pave the way for a truly performant plugin.

woocommerce

A customizable, open-source ecommerce platform built on WordPress. Build any commerce solution you can imagine.

FlexSlider

An awesome, fully responsive jQuery slider plugin

storefront

Official theme for WooCommerce

action-scheduler

A scalable, traceable job queue for background processing large queues of tasks in WordPress. Specifically designed for distribution in WordPress plugins (and themes) - no server access required.

wc-api-php

WooCommerce REST API PHP Library

woocommerce-blocks

(Deprecated) This plugin has been merged into woocommerce/woocommerce

woocommerce-admin

(Deprecated) This plugin has been merged to woocommerce/woocommerce

theme-customisations

wc-smooth-generator

Smooth product, customer and order generation for WooCommerce

woocommerce-ios

WooCommerce iOS app

woocommerce-rest-api-js-lib

New JavaScript library for WooCommerce REST API

woocommerce-android

WooCommerce Android app

woocommerce-gateway-stripe

The official Stripe Payment Gateway for WooCommerce

wc-api-python

A Python wrapper for the WooCommerce API.

facebook-for-woocommerce

A first-party extension plugin built for WooCommerce. Development is managed by Ventures.

woocommerce-google-analytics-integration

WordPress plugin: Provides the integration between WooCommerce and Google Analytics.

wc-api-node

This client is obsolete and will no longer receive updates, a new JavaScript library is available under the name of @woocommerce/woocommerce-rest-api

woocommerce-subscriptions-importer-exporter

Import your subscribers to WooCommerce from a CSV. Or export your subscription data from WooCommerce to CSV.

woocommerce-rest-api-docs

WooCommerce REST API Documentation

woocommerce-accommodation-bookings

An accommodations add-on for the WooCommerce Bookings extension.

woocommerce-language-packs

This repo is deprecated - translation should be done on https://translate.wordpress.org/projects/wp-plugins/woocommerce/

woocommerce-rest-api

This is the WooCommerce core REST API Package. It runs standalone as a feature plugin too.

wc-api-ruby

A Ruby wrapper for the WooCommerce API.

woocommerce-gateway-dummy

A Dummy Payments gateway for your WooCommerce website.

woocommerce-paypal-payments

woocommerce-subscriptions-custom-price-string

Customize the price displayed to your customers for subscription products (or non-subscription product).

woocommerce-gateway-paypal-express-checkout

testimonials

Hi, I'm your testimonials management plugin for WordPress. Show off what your customers or website users are saying about your business and how great they say you are, using our shortcode, widget or template tag.

action-scheduler-high-volume

Increase Action Scheduler time limit, queue size and concurrency to process large queues of actions more quickly on high volume websites with more server resources.

features

Hi, I'm your feature showcase plugin for WordPress. Show off what features your company, product or service offers using our shortcode, widget or template tag.

woosidebars

Replace registered sidebars in your WordPress themes using different conditions such as a specific page, a category or even an individual blog post.

action-scheduler-disable-default-runner

Disable Action Scheduler's default queue runner, by removing it from the 'action_scheduler_run_queue' hook.

woocommerce-sniffs

Collection of PHP_CodeSniffer sniffs for WooCommerce

google-listings-and-ads

Sync your store with Google to list products for free, run paid ads, and track performance straight from your store dashboard.

houston

A child theme for the popular P2 WordPress theme, used on WooThemes internal P2 properties.

wc-api-dev

This is a repository is obsolete, WooCommerce REST API is now located in https://github.com/woocommerce/woocommerce-rest-api

woocommerce-gateway-payfast

South African payment gateway supporting subscriptions, deposits & pre-orders

projects

grant-download-permissions-for-past-woocommerce-orders

This plugin grants downloads permissions like WooCommerce 2.6.x, granting permissions for new files added to a downloadable product. Note that this plugin performs heavy database queries and does not scale. For this reason it has been removed from WooCommerce core.

woocommerce-subscriptions-cancel-subscription-confirmation

Require your subscribers to confirm just-one-more-time before cancelling their subscription.

our-team

Hi, I'm your team profile management plugin for WordPress. Show off what your team members using our shortcode, widget or template tag.

automatewoo-subscriptions

⚠️ DO NOT USE - AutomateWoo's Subscription add-on was merged into AutomateWoo 5.4. Advanced actions for automating a subscription's lifecycle with AutomateWoo.

woocommerce-subscriptions-preserve-billing-schedule

By default, WooCommerce Subscriptions will calculate the next payment date for a subscription from the time of the last payment. This plugin changes that to preserve the original schedule and calculate the next payment date from the scheduled payment date, not the time the payment was actually processed.

bookings-helper

This extension is a WooCommerce Bookings helper which helps you to troubleshoot bookings setup easier by allowing you to quickly export/import product settings.

storechild

Child theme starter for Storefront

woocommerce-icons

sensei-certificates

Hi, I'm the Certificates extension for Sensei.

woocommerce-beta-tester

Run the beta versions of WooCommerce

woocommerce-subscriptions-resource

A library to track and prorate payments for a subscription using WooCommerce Subscriptions based on the status of an external resource.

woocommerce-custom-indexes

pinterest-for-woocommerce

A native Pinterest integration for WooCommerce. Development is managed by Ventures.

woocommerce-subscriptions-skip-pending-cancel

Subscriptions will skip Pending Cancellation and go directly to Cancelled status when Customer cancels their subscription.

woocommerce-gateway-amazon-pay

Amazon Pay Gateway

qit-cli

A Testing Platform for WordPress Plugins and Themes

homepage-control

Re-order or disable the components of your homepage in our newer WordPress themes.

woocommerce-colors

woocommerce-e2e-boilerplate

boutique

woocommerce-product-bundles-bulk-discounts

Bulk discounts and dynamic pricing rules for WooCommerce Product Bundles.

sensei-content-drip

A content drip extension for Sensei.

code-reference

WooCommerce Code Reference Generator

sensei-course-progress

A course progress widget for Sensei.

woocommerce-subscriptions-cancel-on-refund

Cancel a subscription when the most recent order is fully refunded. Both refunds on a parent or renewal order will trigger cancellation, as long as it is the most recent order.

action-scheduler-custom-tables

This plugin is no longer needed. The custom table code is now part of Action Scheduler version 3.0 and newer. If you're using the latest Action Scheduler, you have the most performant schema available.

action-scheduler-timeout-monitor

Gather additional information about scheduled actions which timeout.

subscribe-for-content

A WordPress plugin that allows you to hide content until a user subscribes to your MailChimp mailing list 😍

automations

Various GitHub Action automations to assist with repository project management.

storefront-product-sharing

woocommerce-subscriptions-recalculate-totals

In some cases, if the tax settings change after some subscriptions have been created, their totals need to be recalculated in order to include the proper taxes. This plugin recalculates all the subscriptions totals.

migrator-cli

An experimental WP-CLI based migration tool for moving Shopify stores to WooCommerce.

woocommerce-subscriptions-restrict-product

Restricts subscription products to a certain number of total active (unended) subscriptions on a site.

woocommerce-stellar

Accept payment for WooCommerce orders via Stellar (both the currency and the protocol).

woocommerce-order-tables-feature-plugin

Order tables for WooCommerce.

WooCommerce-Quantity-Increment

Adds back <= WooCommerce 2.2 quantity increment buttons

woocommerce-subscriptions-upstage

Disable Staging Mode for specific subscriptions, as defined in a WCS_UPSTAGED_SUBSCRIPTION_IDS constant.

woocommerce-free-shipping-progress-bar-block

An inner block for the Cart that indicates how much more is needed to get free shipping.

action-scheduler-admin

Action Scheduler screen for the WooCommerce Admin interface

icons-for-features

Optionally display an icon, instead of a featured image, for your Features by WooThemes features.

woocommerce-shortcodes

standard-child-theme-kit

This is a "getting started" child theme kit for Standard by 8BIT.

woocommerce-subscriptions-renewal-logger

Determine why automatic subscription renewal payments aren't being processed despite using an automatic gateway.

woocommerce-composite-products-conditional-images

Composite Products mini-extension that allows you to conditionally overlay additional images over the main Composite Product image.

woocommerce-square

Square POS and Payments Integration

deli

archives

Hi, we're a collection of archive functions for WordPress. Use us to display archives of your content in "Timeline" or "Sitemap" format, using either a shortcode, action or template tag.

wceu23-shipping-workshop-final

subscribe-and-connect

Hi, I'm here to help your visitors subscribe to your content, as well as share it across various social networks.

woocommerce-git-hooks

Collection of WooCommerce core git hooks.

woocommerce-bookings-generator

A small helper plugin for WooCommerce Bookings to generate a large number of Bookings on a test store, to measure how WooCommerce Bookings performs under high load.

sensei-course-participants

This extension has been retired and is no longer being actively maintained.

storefront-extension-boilerplate

wc-php-session-handler

Replaces the core WooCommerce session handler with one which uses php sessions.

woocommerce-legacy-rest-api

The legacy WooCommerce REST API, which used to be part of WooCommerce itself but is removed as of WooCommerce 9.0.

woocommerce-subscriptions-cancel-after-retry

Cancel a subscription after all failed payment retry attempts have failed.

woocommerce-subscriptions-backstage

Disable WooCommerce Subscriptions' Staging Mode completely. Caveat emptor.

woocommerce-subscriptions-disable-paypal

Using WooCommerce Subscriptions? Want to disable PayPal for subscription purchases, but still offer it for buying one-off products? Install and activate this plugin.

woocommerce-product-type-column

WooCommerce Product Type Column

woocommerce-jigoshop-converter

Convert existing shop data from Jigoshop to WooCommerce.

woocommerce-example-package

Example package for a WooCommerce feature plugin that can also be included in core.

woocommerce-core-to-wordpress-org

Plugin deploy script used for Deploying WooCommerce amongst other things.