hello,
i want to create a component for joomla 2.5 / virtuemart 2 for:
-update automatically the database virtuemart, from csv, txt, received by dedicated folders on ftp joomla out.
-Manage the generation of csv file to be transferred by FTP clients to webshop
## Deliverables
Update wholesaler component file in joomla / virtuemart to each file (amount of files larger than 10):
-processing of each file field wholesaler to match the table / field virtuemart generally:
EAN | sku | Brand | Profile | specification | width | series | diameter | load | Speed ??| HV price | stock | bf (public sale price)
there may be split on the labels to extract a word and match the table field virtuemart
- Name of the tire [mark] [Profile] [spec] [width] / [series] R [diameter] [load] [speed] example : michelin energy saver xl rft 205/55 r17 91h
-image using the profile name of the tire as picture
- Put a prefix (initial wholesaler) to the sku to differentiate between wholesalers
it is important to optimize the speed of updating the database virtuemart.
The settings are to achieve:
-keep field matching files wholesalers tables / fields virtuemart
-keep the settings of cutting some labels to extract a word and match the table / fieldvirtuemart
-keep the concatenation to write the name of the tire
You can create generic text tags for the fields "product_s_desc" and "product_desc" example: {profile} {spec} {width} {series} {diameter} {speed} = "energy saver xl rft2055517h"
Fields in the table to add virtuemart are: EAN | brand? | Profile | specification | width |series | diameter | load | speed
The categories are to be created to correspond to the categories of tires such as:
see more in the attached pdf file