is it possible to specify customer created_at date when creating a customer via API

Solved
Kim30
Shopify Expert
137 0 10

Situation: 

We are converting a lot of historical data (orders, customers) and use the date the customer was created for reporting (life time value etc).

When the customer is converted into Shopify (using Matrixify) the customer created date is set to 'now'.

I've tried also creating a customer via the api, and specifying a different created_at date, but when I look at the resulting customer, the date is still the actual time the record was created on the shopify database.

Is there any way to override the customer.created_at date (either at time of creation, or update after the fact)

Thanks!

The eChics are here to help
Accepted Solution (1)

Accepted Solutions
Renars
Shopify Partner
181 22 211

This is an accepted solution.

Hey @Kim30 

Renars here from Matrixify app.
Thank you for mentioning us.

As far as we know, there is no way to set any created_at dates in Shopify. The same applies to Orders, Fulfillments, Transactions, products, Customers, and any other details that have created_at dates.

Other entities, such as Orders and Products have different date fields (processed_at for Orders and published_at for Products) that you can set to a past date and see in the admin, but as far as Shopify documentation shows and we know - Customers do not have such a date.

Just another possibility to look into - if you using Matrixify app also for your reports, if so then maybe you can look into importing Metafield for the customers where you store the created date if its created in the past? Then when exporting Customers with Matrixify, you can also export their Metafields.

I hope this gives some more insight into the Matrixify app and Shopify API.
Hopefully, you can find a solution that works best for you. If you need any Matrixify related assistance - let us know!

Matrixify | Bulk Import Export Update | https://apps.shopify.com/excel-export-import | https://matrixify.app

View solution in original post

Replies 3 (3)
Renars
Shopify Partner
181 22 211

This is an accepted solution.

Hey @Kim30 

Renars here from Matrixify app.
Thank you for mentioning us.

As far as we know, there is no way to set any created_at dates in Shopify. The same applies to Orders, Fulfillments, Transactions, products, Customers, and any other details that have created_at dates.

Other entities, such as Orders and Products have different date fields (processed_at for Orders and published_at for Products) that you can set to a past date and see in the admin, but as far as Shopify documentation shows and we know - Customers do not have such a date.

Just another possibility to look into - if you using Matrixify app also for your reports, if so then maybe you can look into importing Metafield for the customers where you store the created date if its created in the past? Then when exporting Customers with Matrixify, you can also export their Metafields.

I hope this gives some more insight into the Matrixify app and Shopify API.
Hopefully, you can find a solution that works best for you. If you need any Matrixify related assistance - let us know!

Matrixify | Bulk Import Export Update | https://apps.shopify.com/excel-export-import | https://matrixify.app

View solution in original post

Kim30
Shopify Expert
137 0 10

Thanks Renars, that confirms my suspicions.

We are using Metorik for reporting, and as you suggest I will investigate if we can use Metafields to store the actual created date.

I also wanted to say how much we like your app - Matrixify has made it really easy to import several hundred rows of data with minimal problems (except this one  - which is not  a Matrixify problem)

The eChics are here to help
Renars
Shopify Partner
181 22 211

Hi @Kim30 

Amazing to hear that you have been enjoying our app so much! That is what we are aiming for!

If anything - let us know!

Matrixify | Bulk Import Export Update | https://apps.shopify.com/excel-export-import | https://matrixify.app