Registration

We will be doing all the registration of retailers and FMCG, so I need a simple entry point to create all the information.

  • We need these fields pre-set for all registration.

  • I want a + set up so I can have a blank form to create a new registration.

  • The ones with asterisk will saved in a dropdown for future use in other registrations.

  • The ones with 2 asterisks will allow me to add additional categories and brands.

  • No fields are mandatory.

Basic

  1. Retailer Group*

  2. Store brand**

  3. Department*

  4. Role*

  5. Name: first / last

  6. Phone: work / extension  - +971

  7. Phone: mobile  - +9715

  8. What’s app  - +9715

  9. Email:

FMCG

  1. Corporate Group*

  2. Division*

  3. Category**

  4. Brand**

  5. Department*

  6. Role*

  7. Name: first / last

  8. Phone: work / extension  - +971

  9. Phone: mobile  - +9715

  10. What’s app  - +9715

  11. Email:

Additional information for corporate groups and retail groups need this additional information which will be embedded when in the name when I use in dropdown:

  1. Building name

  2. Phone

  3. Street

  4. Area

  5. Emirate

  6. Country

SKU management

Connecting SKUs to people & actions.

The key to automating our buying, billing, tracking & measurement of media is linked to the product SKU that all retailers and FMCG advertisers us to identify each product. To understand this is the path the SKU takes in the entire process.

  • The retailer will give us the SKU of every product that will be featured in an ad or promotion in Excel. 

  • We will create a unique code and attach it to each SKU which will be linked to the retailer (general access), FMCG account (General access), FMCG brand manager (ad buying), FMCG financial (PO, invoice, notices, archive), This will be in the system and identified in the same way as the retailer has the SKU in their system.

  • Let’s come up with a formula to code this.