Price Collection

Price Collection is an additional module in the Sales Supervision application section of the app. It's purpose is tracking and comparing a company's products with products from their competitors.

This file is an extension of InfoDevel/Product-Specs/Module Document.md and will as a base from the Price Collection module will develop.

So from now on, Price Collection does not relate to the module as a whole but just the first section which is tracking and comparing prices for competitive products.

Components

PriCollection Documents

PriceCollection Documents Page

  1. Assuming I have started a day and picked a visit I can navigate to the PriceCollection module by going to the Sales Supervision section and picking the PriceCollection tab

  2. The PriceCollection consists of a list view with all the documents I have created for today for that specific visit. On the header page I can view the trader site name.

    Each document list item must have: DocumentType.Name, DocumentSeries.Name, DocumentNumber, Data, lines count. Each list item will have an ellipsis menu which will consist of the preview/edit/delete actions.

  3. A "+" button is placed on the page which creates a new document. The app navigates me into the document in edit mode.

  4. The document registers locally on my device without any actions but with the following properties:

  • Date and time of visit(the app auto-fills this field from VisitLogin)
  • The user that created the document(auto-filled from Session)
  • Status of the document as open
  • Document gets automatic numbering, type, series and status

  1. Only one document can be open on a visit. If I have a document already open, the "+" will be disabled/not visible.

  2. On a visit I can create a new document and view previous closed ones in read-only mode.

PriceCollection Document Details Page

  1. The document is edited on the PriceCollectionDocumentDetailsPage. The header of the doc has the Trader Site name, doc series and date. A section of the header will be a text entry where I can write comments.

  2. The Details page consists of 2 pages/components:

    • The filters section on top & the list of materials that are loaded based on the filter options
    • A section where I can view/edit the details of each product. On the bottom there is a foldable list where I can preview all the products I have edited/added data.

  3. On the filters page I can either enter a code/name, sort my list based on my group of products or/and competitors, load a pre-designed assortment of products and finally scan the barcode of a product through my camera. I can also hide any competitors' products and clear my filter options through the reset button.

  4. On the filters tab I can pick:

    • GroupItems(categories of products)
    • Competitor(My company's competitor)
    • Assortment(a special custom made group of products consisting of several types)
    • Scan a product or type it's Code(Alternative code given by my company if it's a competitors product)

  5. The list of products initially is empty. I have to use the filters tab to load any products on the list.

  6. When I choose a product the details of that product open up and the item is also highligted on the UI. The products that are my company's are colored in blue and the competitors' are colored in dark yellow.

  7. In the product's details page I have the following information/fields:

    • Label top right which shows my product category.
    • Top of the frame: Type of product(Mine, competitor), name & code of product.
    • Last registered price & date of that record
    • Boolean buttons: Does not exist & special offer
    • Entry: Current Price
    • Entry: Shelf
    • Entry: Faces(how many rows of the product are present)
    • Entry: Comments
    • Button: Clear fields

  8. The PriceCollectionDocumentDetails table on my local db is updated whenever I pick another product. The app saves only if there are changes/additions on the data.

  9. The preview products list has every product I have edited. By pressing one, the app navigates me to it's details page.

  10. If a price was already registered before for that product, that is visible on top of the details page in a frame.

Sync with the Server

  1. The PriceCollection module is a part of Sales Supervision. There is no existing parameter or rule that allows me to make it visible only on certain users, installation.
    • On the Start of Day, I only load data on the tables that are mandatory to have data.
    • If any of the tables have foreign keys on other tables which I do not need on the mobile, I remove any constraint on that columns.
    • VisitLogin is included on the PriceCollectionDocument and PriceCollectionDocumentDetails but are not visible in any way on the UI.

      Table PriceCollectionDocumentDetail does not have CompetitorMaterials but has 3 IDs because I may have PriceCollection for my company's products also.

PriceCollectionDocumentDetails.LastPrice is not affected from any action on the mobile, only the CurrentPrice is edited by the user.

  1. Data sync with the server should update any tables that have to do with the PriceCollection.

  2. When a visit is closed the Document.Status swaps to Closed and the document can sync as part of the visitbundle, as long as the user presses yes on the prompt to upload the visit right away.

  3. When discarding a visit, all entries on the PriceCollectionDocument tables are deleted, same as on the Questionnaires section.

  4. At the end of day, the PriceCollectionDocuments will be sent to the server, in a similar manner as the questionnaires. After they are synced, they will be deleted locally from the device, assuming the end of day is successfull.

Last Updated: