Hello.

Good experience in creating custom plugins for woocommerce is required.

Idea is making tables wp_posts and wp_postmeta tables smaller by removing old orders to new "fast" tables. wp_postmeta table contains 1.5M records at the moment, mostly for woocommerce order details. If we move old orders to separate table, the site will work faster. The only problem that customers of the site won't be able to see the history of orders. So this plugin should modify way woocommerce shows history of orders for customers, using other tables (actually everything should work as now but use other names of tables).

We need to create plugin so standard woocommerce orders pages in my account (i.e. frontend area, where buyers see their orders) -
/my-account/orders/ (attached)
/my-account/view-order/999999/ (attached)
work with other db tables, not original tables but absolutely identical (copied from original and renamed):
wp_woocommerce_fast_orders
wp_woocommerce_fast_ordermeta
wp_woocommerce_fast_order_items
wp_woocommerce_fast_order_itemmeta

These tables above have the same structure/data as the original woocommerce tables used for the pages above:
wp_posts
wp_postmeta
wp_woocommerce_order_items
wp_woocommerce_order_itemmeta

The admin area will keep working as is - using old tables.
But we also need to do a function that copies orders (together with all details form tables above) older than 30 days from the original tables to new tables and deletes them in the original tables.

The project should be done by this week, access to dev server will be provided.

We're interested in future projects with good developer also.

Thanks. Volodymyr.

Update #1 from 19 July 2023

UPDATE: timeline expanded - the project has to be done till Tuesday evening.

Hello.

Good experience in creating custom plugins for woocommerce is required.

Idea is making tables wp_posts and wp_postmeta tables smaller by removing old orders to new "fast" tables. wp_postmeta table contains 1.5M records at the moment, mostly for woocommerce order details. If we move old orders to separate table, the site will work faster. The only problem that customers of the site won't be able to see the history of orders. So this plugin should modify way woocommerce shows history of orders for customers, using other tables (actually everything should work as now but use other names of tables).

We need to create plugin so standard woocommerce orders pages in my account (i.e. frontend area, where buyers see their orders) -
/my-account/orders/ (attached)
/my-account/view-order/999999/ (attached)
work with other db tables, not original tables but absolutely identical (copied from original and renamed):
wp_woocommerce_fast_orders
wp_woocommerce_fast_ordermeta
wp_woocommerce_fast_order_items
wp_woocommerce_fast_order_itemmeta

These tables above have the same structure/data as the original woocommerce tables used for the pages above:
wp_posts
wp_postmeta
wp_woocommerce_order_items
wp_woocommerce_order_itemmeta

Thanks. Volodymyr.

Proposals 2

Tetyana R.

Winning proposal

4 1

Projects 4
Rating -
Rating 370

Budget: 8000 UAH Deadline: 4 days

Hello! I'm ready to create such a plugin before the end of the week.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category PHP

One-time VPS setup

Content Management Systems 43 proposals 11:11

224 USD
Support for the store on OpenCart

Web Programming 76 proposals 4 August

Not specified
Integration of ChoiceQR → KeyCRM via API

Python 78 proposals 4 August

Not specified
Urgent project — Senior WordPress/WooCommerce/Stripe developer to complete VAT setup and

Content Management Systems 36 proposals 2 August

134 USD
WordPress Developer: Greenhouse Harvest API V2 to V3 Upgrade

Website Development 58 proposals 30 July

Not specified

Volodimir Shelever
Kyiv, Ukraine
HivistaSoft

Projects 12
Rating -
Rating 522

Volodimir Shelever

Tetyana R.

Tetyana R.

Proposals are currently absent

Current freelance projects in the category PHP

One-time VPS setup

Support for the store on OpenCart

Integration of ChoiceQR → KeyCRM via API

Urgent project — Senior WordPress/WooCommerce/Stripe developer to complete VAT setup and

WordPress Developer: Greenhouse Harvest API V2 to V3 Upgrade