Announcement

Collapse
No announcement yet.

What is Product Group ID on Flat File Import?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    What is Product Group ID on Flat File Import?

    I’m thinking of adding more products but I cannot give any discounts as I do with current products. So to prevent discounts it looks like I may have to assign “Product Groups…” functions.

    Because data entry puts me to sleep and I make mistakes, I import everything from a flat excel file (4000+ lines).

    So the question is: can I import “product groups” from a flat file. I would assume that this cannot be done, except for one small detail…

    On my excel flat file there is a field named “Product Group ID”. But this field is not mentioned in the “Valid fields for importing” help document, and I don’t know what this field is for.

    During an import, I find the “Product Group ID” field only allows integers and not text. So if the “Product Group ID” field does relate to Product Groups and Discounts how would I use an integer to make a product assignment, which will belong to a product group?

    V 7.03

    #2
    Hi,

    The “Product Group ID” field can be used to import products into a product group. If you take a look at the database and open the Product table and copy out the existing information in the columns Product Reference, Short Description and nGroupID to an excel spreadsheet you will see the following...

    This is from a default Actinic store that has a Default product group "Example Product Group" setup..

    Product reference Short description nGroupID
    1 Diary 1
    1!9 Magazine Subscription 1
    10 All-Purpose Scissors 1
    11 Desktop PC 2
    12 17 inch Monitor 2
    13 19 inch Monitor 2
    14 17 inch TFT Flat Screen 2
    15 Black Ink Cartridge 2
    16 Colour Ink Cartridge 2
    17 Cartridge Twin Pack 2
    19 -1
    2 Diary Inserts for Next Year -1
    3 Movie -1
    4 T-Shirt -1
    5 Calculator 1
    6 Bunch of Flowers 1
    7 Pair of Men's Walking Boots 1
    8 Set of Fragranced Candles 1
    9 Magazine Subscription 1

    See attached file for a clearer picture...

    Here the -1 values are for products that are not assigned to a product group, 1 is for the first created product group, in this case "Example Product Group" and 2 is for a test product group I set up and assigned products to adn is the second product group setup in View | Product groups. Guess you can use this route.

    Kind regards,
    Attached Files
    Bruce King
    SellerDeck

    Comment


      #3
      Excellent! That worked very well thanks Bruce.

      Now I can import more items with product group numbers assigned.

      Comment

      Working...
      X