Greetings!
Last time I asked a question here, you suggested a plugin that had a fantastic positive impact on my website, so I come here again in search of your wisdom.
​
**Context**:
I’m currently reworking my company’s website.
We sell thousands of sounds (Ambiences, Music, SFX). Each of these products come with many metadata attached, as you can see on this [public google sheet]) (there are 3 tabs, one for each type of content).
Each of these need several products variations as we will sell :
1. Base file (no license)
2. Several other licenses
On top of that, each product will be a bundle of the file in several formats (.wav, mp3, ogg).
I’m using the SonaarMP3 plugin and theme, as it comes attached with a great audio player. [Here’s the music store with placeholder tracks for reference]).
​
**Problem**:
We add about 100 new products each month and it’s increasing. We cannot have an employee setting up the products individually.
* I’d like a solution that allows me to update our products list with the newest additions, automatically create variations, possibly update older products.
* I’d like the solution to (if possible) select the track and its other formats to attach to the product.
* Ideally, the process would be automated. I have no idea how to do that, but if it’s not possible, I can do it by hand once per month.
We can’t afford to hire a dev atm.
​
**Solutions I tried**:
I tried the Products Bulk Editor but you can only update 50 products at once and it took ages.
I own ACF pro.
I own ACFAllImport, which may be a solution but I realized product variations are product themselves, which seem to be hard to handle on Microsoft Excel.
​
Do you have a solution to that problem ?
​
Thank you so much for your time!
​
*Our* [*Website*]) *for reference*
[ad_2]