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

[Kim30]

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!

[Renars · 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!

[Kim30]

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)

[Renars]

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!