Include categories in the table Listing mass per company.
Good morning , I'm ready to import my list Listing, however I have a big problem and I wonder if anyone has gone through this and managed to solve .
I have the table Listing for import , however I have another table with the relationship with the listing of each category.
Listing table with column names :
listings -with- attachments.csv
Table Relationship and Listing Categories
Only two columns " Code listing" and " Category Code "
Example : Listing : East Shopping Center "code listing" 02 . Listing all ok in the table more missing classes who are related line by line in the table Listing and Relationship Categories
Thus the categories in this table Relationship line by line for each client
Cod
" Code listing" and "Code Category "
02--------------- 03 - Supermarket
02--------------- 04 - Cinema
02--------------- 07 - Hairdresser
02--------------- 08 - PetShop
02--------------- 09 - Watches
02 --------------- 13 - Ice Cream
02 --------------- 15 - Bank
02 --------------- 16 - House Exchange
02 --------------- 17 - Clothing Store
02 --------------- 18 - Hotel
02 --------------- 22 - Pharmacy
How can I incorporate these categories listed line by line in the table " Relationship " to table " Listing " in the field " listing_category "
Remembering Enterprises has over 100 categories , impossible to client by client.
I appreciate the attention and help.