Batch Renaming/Resizing of Product Images

We require a fix to a solution which automates batch renaming/resizing of images based on data currently contained in a excel spreadsheet. The script is written in Python.

The solution is very nearly complete. The programmer who was working on the script before is no longer available to apply the small fix to the script or be available for future updates.

The files being renamed and resized are product image files of differing dimensions for a website.

The bug in the script currently is that it does not use the correct source image when it resizes/renames the images. The script currently uses the same source image for each attribute.

I have attached the:

• Current example output of images from the script (based on Product SKU u1095)

• Desired example output of images once this fix is applied (based on Product SKU u1095)

• Source images used (based on Product SKU u1095)

• The spreadsheet the script uses is attached ([url removed, login to view])

“Product Images” sheet includes the original file name of the source image in the “Image 1” column. This name corresponds to the image file name in the images directory.

The desired product image file names are stored in the other sheet “Product Media Integration”. In the “Media File Name” column.

The data is matched up via the “Attribute1 (Colour/Finish) column in “Product Images” sheet and “Attribute1 Association” in “Product Media Integration” sheet.

The images must be renamed according to size with the correct file name and placed in the correct dimension directory.

Correspondence done via Skype, Email and telephone if required.

Current python script looks like this:

[url removed, login to view]

For "Media Key" small and "Media Key" xsmall the "Attribute1 Association" in "Product Media Integration" sheet will always be blank cells. The Image should use the first source image available on the parent sku in "Product Images".

Kemahiran: Python

Lihat lagi: tinypic. com, tinypic com, python updates, programmer names, programmer for spreadsheet, it programmer names, dimension data, excel spreadsheet programmer, xlsx, source product, Resizing, renaming, renaming i, python excel, product source, product sku, product images, images excel, file renaming, excel python, batch, batch file, data integration excel, sku updates, images size

Tentang Majikan:
( 3 ulasan ) London, United Kingdom

ID Projek: #1558046

Dianugerahkan kepada:


Hello. I am an experienced python developer. I can have this script fixed for you. Check pmb for more questions. Regards, Arthur.

$100 USD dalam 4 hari
(57 Ulasan)

7 pekerja bebas membida secara purata $105 untuk pekerjaan ini


I can deliver the script

$150 USD dalam 2 hari
(15 Ulasan)

Hello, here is python coder ready to do the fix

$77 USD dalam sehari
(4 Ulasan)

Hello, I have experience in Python scripting. Best regards, Polin

$40 USD dalam 2 hari
(0 Ulasan)

Pls check PMB.

$250 USD dalam sehari
(0 Ulasan)

I do this stuff for fun! I can get the script working. Also, if you need any macro/VB integration or work I can get it going for ya. Cheers!

$75 USD dalam sehari
(0 Ulasan)

Hello, I have experience with Python scripting. I worked on a proxy module for the Dept of Justice here in Australia a few years back and use Python for various prototyping needs. From what you have described, th Lagi

$100 USD dalam 2 hari
(0 Ulasan)

Hello, I am an experienced programmer working for a UK Plc. I believe I can complete this job on time and budget. I have sent you a PM with more details.

$40 USD dalam 3 hari
(0 Ulasan)