There is an existing Excel VBA script that we are using to export Shopify CSV files from, based on data we add to the spreadsheet. It already works pretty well but it needs a few updates to address some improvements we need to make to it.
#1 update saving of CSV files from ANSI to UTF-8 format
[login to view URL]
#2 hardcode a subfolder (/CSV) to output CSV files to so it doesn't export to the same folder that the CSV file is located and also modify the NP output to go to (/CSV-NP) folder instead as well so it is easier to keep those separate
Maybe this change for those two above folders? It should check to ensure that folder exists before doing this and if it does not, then just save to the same folder as the main CSV.
( If sInc = "" Then
sCSVPath = [login to view URL] & "\CSV\" & "XXXXXX-" & Format$(Now, "MMDDYY-hhmmss") & "[login to view URL]"
sCSVNoImgPath = [login to view URL] & "\CSV-NP\" & "XXXXXX-NP-" & Format$(Now, "MMDDYY-hhmmss") & "[login to view URL]"
sCSVPath = [login to view URL] & "\" & Format$(sInc, "000000-") & Format$(Now, "MMDDYY-hhmmss") & "[login to view URL]"
sCSVNoImgPath = [login to view URL] & "\" & Format$(sInc, "000000-NP-") & Format$(Now, "MMDDYY-hhmmss") & "[login to view URL]"
#3 option (checkbox) that when selected (it is unselected by default), doesn't export anything in Column H, "Collection" for certain specific collection upload - maybe place this in cell H1 to keep it out of the way?
#4 add 9 columns (CL through DC) to the XLS file for size and other variables to be integrated into HTML before all of the CSV outputs (%a, %b, etc). This script needs to insert those cell values into the code from Column I labeled "Body (HTML)" when it is creating the CSV so those values appear in the CSV output.
#5 new columns (DE through DN) for up to 10 photo URLs that are already uploaded to Shopify, new tab (CSV Output CDN) and new CSV output file for listing hosted shopify images, a means to input a CSV to match up the pictures and when the CSV is updated, match up the images and save shopify CDN photo URLs to DE through DN if they exist so making changes is quicker. It should overwrite those DE through DN URLs if a new CSV is uploaded. It might be necessary to better sync up ALT text with image URLs in a different or better way?
#6 when the script runs and if it does generate any errors, highlight the background of all of the *specific* cells that caused that error to occur. Also, remove the errors of any cells that no longer produce an error (typically because the correct values have been inserted or corrected). Having it say that there was an error isn't helpful in tracking down what caused that error and reviewing the Error tab helps some but still doesn't easily pinpoint things.
Removed requirement for #5, it is not in the scope of this current bid.
6 freelancer đang chào giá trung bình $109 cho công việc này
Hi, I have good experience in excel VBA macro programming. I can work for you on this project. Please provide sample excel file and also provide more information on point# 3 to 6. Thanks, manishadk