How to automate data export from product form to Excel spreadsheet?

How to automate data export from product form to Excel spreadsheet?

KSMGaming
New Member
15 0 0

Hello!

My company hosts events in which competitors are required to fill out a form prior to adding product to cart. 
I have this form written in the code and the information is then displayed in the orders sheet - we then take this information and manually enter it into our google spreadsheet

I am looking for an app to replace the form written in code that will automatically  generate the data into the spreadsheet (or at least allow to export via excel)

Cheers
KSMGaming

Replies 3 (3)

HymnZ
Shopify Partner
399 6 49

What do you mean by "form written in code"? You can use Excel VBA for this purpose and a private Shopify app to get the required data, but I can offer you a better solution when you can tell what "form written in code" is.

My speciality lies in making Shopify work for your requirements, not the other way round. HMU on email: hymnz@outlook.com or on skype: hymnzzy

If you like my work, consider supporting me 🙂 https://www.buymeacoffee.com/hymnz
KSMGaming
New Member
15 0 0

as seen here 
https://ksmgaming.com/collections/tournaments/products/december-13-trios-enforcer-7-0


in the product template, i have a coded in a simple form -> this information is displayed in the orders -> we then take this information and copy and paste it manually into excel.
i'm looking for an app to do this for us

form code example below

<form autocomplete="off">
<p class="cart-attribute__field">
<input type="hidden" name="attributes[Do you acknowledge you have read and agree to all KSMGaming rules]" value="No">
<input required class="required" type="checkbox" name="attributes[Do you acknowledge you have read and agree to all KSMGaming rules]" value="Yes"{% if cart.attributes["Do you acknowledge you have read and agree to all KSMGaming rules"] == "Yes" %} checked{% endif %}>
<label>Do you acknowledge you have read and agree to all KSMGaming rules</label>
</p>

<p class="cart-attribute__field">
<label for="email-address">Email Address</label>
<input required class="required" id="email-address" type="text" name="attributes[Email Address]" value="{{ cart.attributes["Email Address"] }}">
</p>
<p class="cart-attribute__field">
<label for="team-name">Team Name</label>
<input autocomplete="off" required class="product_field_required" id="team-name" type="text" name="attributes[Team Name]" value="{{ cart.attributes["Team Name"] }}" style="border:0px;">
</p>
<p class="cart-attribute__field">
<label for="activision-account-numbers-included">Activision Account (#numbers included)</label>
<input autocomplete="off" required class="required product_field_required" id="activision-account-numbers-included" type="text" name="attributes[Activision Account (#numbers included)]" value="{{ cart.attributes["Activision Account (#numbers included)"] }}">
</p>
<p class="cart-attribute__field">
<label for="kd-ratio">K/D Ratio </label>
<input autocomplete="off" required class="required product_field_required" id="kd-ratio" type="number" step="0.01" pattern="\s*-?[1-9]\d*(\.\d{1,2})?\s*" title="Number with two decimals" name="attributes[K/D Ratio ]" value="{{ cart.attributes["K/D Ratio "] }}">
</p>
<p class="cart-attribute__field">
<label for="stream-url-only-1-required-per-team">Stream URL (Only 1 required per team)</label>
<input autocomplete="off" id="stream-url-only-1-required-per-team" type="text" style="color:white" name="attributes[Stream URL (Only 1 required per team)]" value="{{ cart.attributes["Stream URL (Only 1 required per team)"] }}">
</p>
<p class="cart-attribute__field">
<label for="discord-name-check-in-member-required-only">Discord name (Check in member required only)</label>
<input autocomplete="off" id="discord-name-check-in-member-required-only" type="text" style="color:white" name="attributes[Discord name (Check in member required only)]" value="{{ cart.attributes["Discord name (Check in member required only)"] }}">
</p>

<p class="cart-attribute__field">
<label>Competing time</label><br>
<select required class="required" id="competing start-time? (Between 6am and midnight PST)" name="attributes[Competing time]">
<option value="1"{% if cart.attributes["Competing time"] == "1" %} selected{% endif %}>1</option>
<option value="2"{% if cart.attributes["Competing time"] == "2" %} selected{% endif %}>2</option>
<option value="3"{% if cart.attributes["Competing time"] == "3" %} selected{% endif %}>3</option>
<option value="4"{% if cart.attributes["Competing time"] == "4" %} selected{% endif %}>4</option>
<option value="5"{% if cart.attributes["Competing time"] == "5" %} selected{% endif %}>5</option>
<option value="6"{% if cart.attributes["Competing time"] == "6" %} selected{% endif %}>6</option>
<option value="7"{% if cart.attributes["Competing time"] == "7" %} selected{% endif %}>7</option>
<option value="8"{% if cart.attributes["Competing time"] == "8" %} selected{% endif %}>8</option>
<option value="9"{% if cart.attributes["Competing time"] == "9" %} selected{% endif %}>9</option>
<option value="10"{% if cart.attributes["Competing time"] == "10" %} selected{% endif %}>10</option>
<option value="11"{% if cart.attributes["Competing time"] == "11" %} selected{% endif %}>11</option>
<option value="12"{% if cart.attributes["Competing time"] == "12" %} selected{% endif %}>12</option>
</select>
</p>

<p class="cart-attribute__field">
<label>AM or PM</label><br>
<select required class="required" id="am-or-pm" name="attributes[AM or PM]">
<option value="AM"{% if cart.attributes["AM or PM"] == "AM" %} selected{% endif %}>AM</option>
<option value="PM"{% if cart.attributes["AM or PM"] == "PM" %} selected{% endif %}>PM</option>
</select>
</p>
<p class="cart-attribute__field">
<label for="time-zone">Time Zone</label>
<input required class="required" id="time-zone" type="text" name="attributes[Time Zone]" value="{{ cart.attributes["Time Zone"] }}">
</p>

<p class="cart-attribute__field">
<label>Do you acknowledge that KSMGaming is allowed to use any of your game footage played during our tournament.</label><br>
<input required class="required" type="radio" name="attributes[Do you acknowledge that KSMGaming is allowed to use any of your game footage played during our tournament.]" value="Yes"{% if cart.attributes["Do you acknowledge that KSMGaming is allowed to use any of your game footage played during our tournament."] == "Yes" %} checked{% endif %}> <span>Yes</span><br>
</p>
IF YOU ARE PAYING FOR MORE THAN 1 PERSON PLEASE FILL OUT BELOW

<p class="cart-attribute__field">
<label for="player-2-activision-account">Player 2 activision account</label>
<input id="player-2-activision-account" type="text" name="attributes[Player 2 activision account]" value="{{ cart.attributes["Player 2 activision account"] }}">
</p>

<p class="cart-attribute__field">
<label for="player-2-kd-ratio">Player 2 K/D Ratio</label>
<input id="player-2-kd-ratio" type="text" name="attributes[Player 2 K/D Ratio]" value="{{ cart.attributes["Player 2 K/D Ratio"] }}">
</p>

HymnZ
Shopify Partner
399 6 49

You're storing the details in cart attributes. Splendid. There's an specifically for for requirement - EZ Exporter ‑ Data Exports – Ecommerce Plugins for Online Stores – Shopify App Store

My speciality lies in making Shopify work for your requirements, not the other way round. HMU on email: hymnz@outlook.com or on skype: hymnzzy

If you like my work, consider supporting me 🙂 https://www.buymeacoffee.com/hymnz