Product personalisation upload with a CSV file

[danmurrell]

Hi all, looking for some well needed advice.

I have a supplier that offers custom personalised products. They offer a CSV with all the personalisation options as well. which are all single line text inputs. 

Here is an example of the csv

products_sku	instruction_id	instruction_seq_no	instruction_label	constraint_id	instruction_value_max	instruction_mandatory	instruction_fixed	instruction_fixed_value
10101020104	1	1	Name		15	FALSE	FALSE
10101020104	2	2	Message		30	FALSE	FALSE
10101020104	3	3	Message		30	FALSE	FALSE
10101020104	4	4	Message		30	FALSE	FALSE
10101020104	5	5	Year		4	FALSE	FALSE
10101020106	1	1	Name		15	FALSE	FALSE
10101020106	2	2	Message		40	FALSE	FALSE

This is an example website: https://www.prezzybox.com/personalised-me-to-you-the-one-i-love-book.aspx that offers the personalisation option. This is what I'm trying to achieve. Does anyone who has done anything similar or have an idea of how to go about it?

There are 1000+ products, and I have all the information, but I am finding it hard to find a way to set it up. I have tried most of the apps on shopify and none seem to offer what I am looking for.

Does anyone have any suggestions for a desperate shopifyer?

Thanks in advance!

[Eli_Kickflip]

Hi @danmurrell ,

I recommend trying Kickflip to create a product customizer. With an intuitive and elegant interface, customers can visualize endless product variants. Also, Kickflip offers Conditional Logic, which enables you to offer an efficient customization workflow based on your clients' choices. I am confident you can create what you are looking for with our app.

I encourage you to check out our Youtube channel to see our solution in action. You can even try it for free by creating your account here.

Do not hesitate to contact us at help@gokickflip.com if you have any questions!

The Kickflip Team

[danmurrell]

Hi there thank you for your reply, I have already tried your app and I can't see where the options can be uploaded with a CSV file.

[Sue_de_Nimm]

Theres no import/upload. Ive checked with their helpdesk. ZERO use for 99.9% of us.

[gr_trading]

Hi @danmurrell ,

Yes, its doable with the help of metafield and custom code in your store.

We can discuss the implementation in details our details are in post footer.

[EasifyApps]

Hi @danmurrell,

The Easify Product Options app (free plan available) can assist you in setting up those custom text fields for all of your products in just a few minutes 🤗. Here's an example:

In-app setup using Text Area (long text field) & Text Box (short text field):

If you wish to hide the text fields to display only when customers opt for customization, you can add a Checkbox. Then, apply Conditional logic so the above text fields only appear when the checkbox is selected. For example:

[danmurrell]

Hi thank you for your comment, I have already tried your app. The conditions worked however they did not when I uploaded a CSV file, I reached out to support and was told it couldn't be done and had to be done manually.

[EasifyApps]

Hi @danmurrell,

We do offer an import/export function, but it requires modifying your CSV to adhere to our format before importing, which might not be the most efficient approach.

Instead, consider creating just 1 option set and utilizing our product assignment feature to add all the custom options to your products. You'll have 3 options to choose from:

1. Add options to all products.
2. Add options to specific products by manually selecting them.
3. Add options to specific products by setting conditions (based on product collections, tags, titles, etc.).

I believe either the first or third method would suit your needs well. Let me know your thoughts.

[danmurrell]

Hi again, I tried modifying the CSV and added based on the product tag, however when I uploaded it, the options where there but it ignored the condition of the tag. I could do it manually as you suggest but i have around 4000 products, each with different customisation. Can you be more specific about modifying the CSV as I could be getting it wrong and the could be the reason it isn't recognising the product tags when I upload?