Looking to hire a WooCommerce B2B Industrial developer with custom fields and quoting system.

This is very rough idea for my ecommerce website I need built. I apologize if it's a bit of Chat GPT puke, but it's a rough idea of what I want. Here it is:

It's for a fully functional industrial product selling website - Think Grainger

Ecommerce Website Requirements:

1.)MySQL DB functionality

a. Quotes

b. Orders

c. Images

d. Videos

e. Invoices

f. Inventory register by orders; min max level sets

i. MFR’s Products

ii. CSV import/export

Supplier updates

Admin dashboard

Product import tool

Quote engine

Invoice engine

Payment tracking

g. Reporting

2.) Woo Commerce

3.) VectorSupply.com web domain

1️⃣ Customers Table

customers

customer_id (PK)

company_name

contact_name

email

phone

billing_address

shipping_address

tax_exempt_flag

credit_limit

payment_terms

created_date

________________________________________

2️⃣ Products Table

products

product_id (PK)

sku

manufacturer

part_number

description

condition_code

cost

sell_price

qty_available

weight

image_path

active_flag

Indexes on:

sku

part_number

manufacturer

This is critical for industrial search speed.

________________________________________

3️⃣ Quotes (Header)

quotes

quote_id (PK)

customer_id (FK)

created_date

expiration_date

status (Open, Approved, Converted, Lost)

total_amount

sales_rep_id

________________________________________

4️⃣ Quote Line Items

quote_lines

line_id (PK)

quote_id (FK)

product_id (FK)

qty

price

extended_price

________________________________________

5️⃣ Orders (Header)

orders

order_id (PK)

customer_id (FK)

quote_id (nullable FK)

order_date

status (Pending, Paid, Shipped)

subtotal

tax

shipping

total

payment_status

paid_date

________________________________________

6️⃣ Order Lines

order_lines

line_id (PK)

order_id (FK)

product_id (FK)

qty

price

extended_price

________________________________________

7️⃣ Payments Table

payments

payment_id (PK)

order_id (FK)

amount

payment_method

transaction_id

payment_date

________________________________________

8️⃣ Sales Reps Table

Because your format includes ASM / Territory.

sales_reps

rep_id

name

territory

commission_rate

TRANSACTION FLOW

Customer requests quote →

Quote is sent to customer→

Convert to order →

Invoice generated →

Payment recorded →

Inventory is adjusted

Status updated automatically.

Custom Fields

Add:

• Condition Code (RISCN1, etc.)

• Territory

• Tax Exempt?

• Florida/Hillsborough Cty. Taxes collected and reported

• Sales Rep

• Credit Terms

• Paid in Full flag

2️⃣ Quote Plugin

Allow:

• Request quote

• Admin price adjustment

• Convert to order

________________________________________

3️⃣ Invoice Plugin

Auto generate PDF invoices

Track paid date

________________________________________

4️⃣ Advanced Search

Critical for industrial:

• Search by part number

• Manufacturer

• SKU

• Description keywords

________________________________________

5️⃣ Bulk CSV Product Loader

You manage products in Excel.

Upload 500–5,000 at a time.

Apply Now

Apply Now