DougStroud
Well-known Member
- Joined
- Aug 16, 2005
- Messages
- 2,976
- Office Version
- 365
- Platform
- MacOS
One of the projects I have been thinking about doing is creating a master file that stores product data for future and current items that I will purchase for my store. The pertinent data is the same from all the companies, but the structure in which I receive it is always different, not consistent structure.
Initially, I am looking for suggestions of how to approach this rather than a specific answer right at the moment.
Suggestions on which way to handle this and then on how-- e.g. All in Excel or incorporate Access. I have extremely limited exposure to Access, so if Access is the way to go, I will need a little more help once execution begins, the how question details: on whether to store the data in one main file w/ all the companies, part numbers, part names, color, sizing, pricing, by season, or store the data in individual files by company name w/ part numbers, part names, color, sizing, by season, stored in the same sub-directory.
Three different examples below that will demonstrate what I am provided by the companies initially to build the file I wish to store the data in.
I had to add these into different posts to allow to upload, sorry if this makes this hard to read.
Also thanks to everyone who reads and contributes...
Doug
Initially, I am looking for suggestions of how to approach this rather than a specific answer right at the moment.
Suggestions on which way to handle this and then on how-- e.g. All in Excel or incorporate Access. I have extremely limited exposure to Access, so if Access is the way to go, I will need a little more help once execution begins, the how question details: on whether to store the data in one main file w/ all the companies, part numbers, part names, color, sizing, pricing, by season, or store the data in individual files by company name w/ part numbers, part names, color, sizing, by season, stored in the same sub-directory.
Three different examples below that will demonstrate what I am provided by the companies initially to build the file I wish to store the data in.
I had to add these into different posts to allow to upload, sorry if this makes this hard to read.
Also thanks to everyone who reads and contributes...
Doug
DVS BTS 2006.xls | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |||
6 | SHOP: | PHONE: | ||||||||||||||||||||||||||
7 | ADDRESS: | ORDERED BY: | ||||||||||||||||||||||||||
8 | P.O.# | SHIP DATE: | ||||||||||||||||||||||||||
9 | PRICE SHEET / SUMMER 2006 / DOMESTIC | |||||||||||||||||||||||||||
10 | MENS SUMMER 2006 SHOE STYLES | |||||||||||||||||||||||||||
11 | STYLE | COLOR | CODE | ITEM # | NEW-RE-C/O | AVAIL | 5 | 6 | 6 | 7 | 7 | 8 | 8 | 9 | 9 | 10 | 10 | 11 | 11 | 12 | 13 | 14 | 15 | UNITS | PRICE | TOTAL | ||
12 | TAYLOR SECT | BLACK LEATHER | BLKF | S/TAYLOR SECT | NEW | 5/10 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 11 | $40.00 | $ 440.00 | ||||||||||
13 | TAYLOR | WHITE LEATHER | WHIT | S/TAYLOR SM | NEW | 5/10 | - | $36.00 | $ - | |||||||||||||||||||
14 | TAYLOR | BLACK NUBUCK | BLKT | S/TAYLOR SM | NEW | 5/10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 9 | $36.00 | $ 324.00 | ||||||||||
SHOES PAGE 1 |