I currently receive my CSV files from a third party provider with all listings from there site within it.
now they have their tabs as this.
program_name, merchant_id, code, description, url, start_date, end_date, region, Date_Added
but my site only allows me to upload these files as the following as the above will not work.
SKU, tagline, post_author, post_date, post_content, post_title, post_excerpt, post_type, code, Date_Added, category, description, email, end_date, expires, featured, hits, image, images, link, merchant_id, no_votes, packageID, package_access, pexpires, program_name, region, starts, start_date, style, tagline, type, url, yes_votes, store
is there a program or a tool within excel that will automatically rename the files and add new ones to save me the time on editing them. as I have over 400 items it becomes very time consuming.
please can someone point me in the right direction? thanks.