Data Processing and Entry Job Project For ionix

Same Project as last except 2 new things please. Here is the CSV file with all the details you can download; [login to view URL] The Duplicates have to be removed, theres like 30,000 lines of records but actual products consist of around 7000-8000 products only. Also the CSV file above only contains the records of the sub-categories. This CSV file contains info for the Main and Sub categories. [login to view URL] ------------------ We have around 8000 products that need uploading, We have a CSV file with close to 32,000 records, the reason for this is for every 4 lines of records, 3 are duplicates. So you will need to remove all duplicates from the CSV file. Most likely you can do this in bulk through Macros or some function you know. Also in the CSV file, the Categories are actually Sub-categories. The download link above lists the Main Level categories in which these Sub-Categories in the CSV file must go under before you upload. You do not have to upload any images. We will do that. You only have to prepare the CSV file correctly and upload the products to our store. You must also edit the main/sub category to match the store category structure before entering it into the csv file otherwise duplicate categories will be generated. Correct: category_path Automotive/Airplanes Automotive/All Cars Wrong category_path: AUTOMOTIVE/Airplanes Automotive/ALL CARS Also note the image file name is the actual SKU product code. eg: Image file name: [login to view URL] SKU: A8178B-md product_full_image: A8178B-md product_thumb_image: A8178B-md The excel file we will send you will contain the image file names like this per product: [login to view URL] Its your job to remove the ( .jpg ) part and ad the balance ( A8178B-lg )as the SKU code for the product. Image with a A8178B-lg-b ( b Extension ) are for black t-shirts, the b must not be removed. We are stocking t-shirt into our store so have to be very careful in the image filenames. eg: White t-shirts files are like these below: [login to view URL] [login to view URL] [login to view URL] [login to view URL] eg: Black t-shirts files are like these below: [login to view URL] [login to view URL] [login to view URL] [login to view URL] see the difference ( black has a b_ before [login to view URL] ) Total csv fields product_name category_path product_full_image product_thumb_image product_price product_s_desc product_desc attribute --------------------------- The following dont require work, just same entry in all fields so copy and paste in bulk: product_price (Entry 14.50 ) product_s_desc (Entry Small ) product_desc ( Entry main ) attribute ( Entry Attri ) ------------------------------ The following will require you to work on accurately. product_sku product_name category_path product_full_image product_thumb_image After you finish the Upload, we will run a script and insert the Additional Images, product prices, Small and Main Description and product Attributes in bulk. We will send PHPMyAdmin Access and Joomla Super Admin Access. Thank you very much !