B2B data changes

[ckelley-magento]

Tables to be created

admin_users

• user_id (PK)
• email
• is_active (boolean)

Tables to edit

quote

(edited to move status + expiration_period to negotiable_quote)

• Add more rows to this and it's sub tables? There are only 101 rows here.
  • It is fine to only add rows here – that would just show that only 100 carts were negotiated by a sales rep – totally fine.
• reserved_order_id is missing
  • This should be a reference to sales_order.increment_id

negotiable_quote

• status is always blank. Please use these values to populate the field:
  • ~18% Submitted by customer
  • ~15% Processing by admin
  • ~50% Ordered
  • ~10% Expired
  • ~7% Declined
• expiration_period is always blank
  • This should have dates randomly distributed over the past 12 months

company_advanced_customer_entity

• This whole table is blank according to MBI (including remote queries).

General

Many tables seem to not have a PK indicated, which is making it difficult to sync them. Examples:

• company_payment
• quote_item

We fixed this for a few tables already, but there are several steps involved that don't seem to always work.

[ckelley-magento]

Note: More issues will be created – there are the initial ones.

[chris-schmid]

A few additional tables to edit:

shared_catalog

• Cut this down to just 5 or so rows like the following:

INSERT INTO `shared_catalog` (`entity_id`, `name`, `description`, `customer_group_id`, `type`, `created_at`, `created_by`, `store_id`) VALUES
(1, 'Default (General)', 'Public shared catalog', 2, 1, '2015-06-23 20:04:44', 1, NULL),
(2, 'Wholesale', NULL, 3, 0, '2016-06-23 20:50:56', 1, 0),
(3, 'Retailer', NULL, 4, 0, '2016-06-23 20:50:57', 1, 0),
(4, 'US Resellers', NULL, 5, 0, '2016-06-23 20:50:58', 1, 0),
(5, 'CA Resellers', NULL, 6, 0, '2016-06-23 20:50:59', 1, 0);

company

• status change to "1" for all companies to flag as active
• sale_representative_id should reference admin_user.user_id, with an even spread of companies amount admin users
• customer_group_id should reference customer_group.id. Please populate field with following breakdown:
  • 2: ~50% of companies
  • 3: ~20% of companies
  • 4: ~10% of companies
  • 5: ~12% of companies
  • 6: ~8% of companies

[ckelley-magento]

Blank tables:

These tables are blank according to MBI (including remote queries).

• company_advanced_customer_entity
• company_credit

Tables to edit (cont'd)

• sales_order
  • Please add increment_id. This is the key to reference the quote tables.

[bengarvey]

These are a lot of items. It's generally better to break them down into smaller requests.

[bengarvey]

@ckelley-magento I don't see a status column on the quote table.

[ckelley-magento]

@bengarvey status is on negotiable_quote; I apologize.

Do you want me to split the stuff you didn't address in "Fix/b2b polish" PR into separate issues?