PLANOGRAM ATTRIBUTE RESOLUTION
Methods, systems, and computer readable storage media are disclosed that aid in the creation and/or updating of floor plans and associated planograms. Some embodiments utilize an assignment table to maintain relationships between floor plans and associated planograms. Some embodiments also locate planograms for display fixtures of a floor plan based on attributes for the display fixture and products to be displayed.
1 . A computer-implemented method, comprising:
identifying, from a floor plan, attributes for a display fixture and products to be displayed by the display fixture;
obtaining a planogram based on an electronic database of planograms and the identified attributes of the display fixture and products to be displayed; and
creating a relationship between the floor plan and the obtained planogram for the display fixture.
2 . The computer-implemented method of claim 1 , wherein said obtaining comprises:
identifying a planogram in the electronic database having attributes that match the identified attributes for the display fixture and products to be displayed; and
selecting the identified planogram as the obtained planogram for the display fixture.
3 . The computer-implemented method of claim 1 , wherein said obtaining comprises:
identifying a planogram in the electronic database having attributes that match a subset of the identified attributes for the display fixture and products to be displayed;
copying the identified planogram to create a new planogram in the electronic database;
updating the new planogram to match the identified attributes for the display fixture and products to be displayed; and
selecting the new planogram as the obtained planogram for the display fixture.
4 . The computer-implemented method of claim 1 , further comprising removing products from the new planogram.
5 . The computer-implemented method of claim 1 , wherein:
the floor plan specifies the attributes for the display fixture and products to be displayed; and
the attributes include at least a fixture type and width for the display fixture.
6 . The computer-implemented method of claim 1 , wherein:
the floor plan specifies the attributes for the display fixture and products to be displayed; and
the attributes include at least an assortment designation for the products to be displayed.
7 . A non-transitory, computer readable storage medium, comprising a plurality of instructions that in response to being executed results in a computer system:
retrieving a floor plan based on a queue of floor plans to be processed;
identifying, from the retrieved floor plan, attributes for a display fixture of the floor plan and products to be displayed by the display fixture;
obtaining a planogram based on an electronic database of planograms and the identified attributes; and
updating an assignment table to reflect a relationship between the floor plan and the obtained planogram for the display fixture.
8 . The non-transitory, computer readable storage medium of claim 7 , wherein the plurality of instructions further result in the computer system:
identifying a planogram in the electronic database having attributes that match the identified attributes for the display fixture and products to be displayed; and
selecting the identified planogram as the obtained planogram for the display fixture.
9 . The non-transitory, computer readable storage medium of claim 7 , wherein the plurality of instructions further result in the computer system:
identifying a planogram in the electronic database having attributes that match a subset of the identified attributes for the display fixture and products to be displayed;
copying the identified planogram to create a new planogram in the electronic database;
updating the new planogram to match the identified attributes for the display fixture and products to be displayed; and
selecting the new planogram as the obtained planogram for the display fixture.
10 . The non-transitory, computer readable storage medium of claim 9 , wherein the plurality of instructions further result in the computer system removing products from the new planogram.
11 . The non-transitory, computer readable storage medium of claim 7 , wherein:
the floor plan specifies the attributes for the display fixture and products to be displayed; and
the attributes include at least a fixture type and width for the display fixture.
12 . The non-transitory, computer readable storage medium of claim 7 , wherein:
the floor plan specifies the attributes for the display fixture and products to be displayed; and
the attributes include at least an assortment designation for the products to be displayed.
13 . A computer system, comprising
one or more storage devices that store retail store database, a floor plan database, a planogram database, an assignment table, and a queue, wherein the retail store database comprises information for a plurality of retail stores, the floor plan database comprises a plurality of floor plans for the plurality of retail stores, the planogram database comprises a plurality of planograms, the assignment table stores a plurality of relationships that relate planograms of the planogram database to floor plans of the floor plan database, and the queue identifies floor plan of the floor plan database to be processed; and
a processor that:
retrieves from the floor plan database a floor plan identified by the queue;
identifies, from the retrieved floor plan, attributes for a display fixture of the floor plan and products to be displayed by the display fixture;
obtains a planogram based planograms of the planogram database and the identified attributes; and
updates the assignment table to reflect a relationship between the retrieved floor plan and the obtained planogram for the display fixture.
14 . The computer system of claim 13 , wherein the processor further:
identifies a planogram of the planogram database having attributes that match the identified attributes for the display fixture and products to be displayed; and
selects the identified planogram as the obtained planogram for the display fixture.
15 . The computer system of claim 13 , wherein the processor further:
identifies a planogram of the planogram database having attributes that match a subset of the identified attributes for the display fixture and products to be displayed;
copies the identified planogram to create a new planogram in the planogram database;
updates the new planogram to match the identified attributes for the display fixture and products to be displayed; and
selects the new planogram as the obtained planogram for the display fixture.
16 . The computer system of claim 14 , wherein the processor further removes products from the new planogram.
17 . The computer system of claim 13 , wherein:
the retrieved floor plan specifies the attributes for the display fixture and products to be displayed; and
the attributes include at least a fixture type and width for the display fixture.
18 . The computer system of claim 13 , wherein:
the retrieved floor plan specifies the attributes for the display fixture and products to be displayed; and
the attributes include at least an assortment designation for the products to be displayed.